microsoft excel
Is Managing QuickBooks Purchase Orders Driving You Insane?
We have one vendor that we buy the majority of our materials from, so we have a lot of different Purchase Orders for that vendor. My problem is, a lot of times our Subcontractors or Vendors don’t reference our Purchase Order number on their invoices, only the job – so I have a hard time figuring out which of the Purchase Orders the bill belongs to. I’ve created Excel spreadsheets for each job which lists all of the Vendors we’ve created Purchase Orders for, the Purchase Order Number, cost/Item code, the amount of the PO, when we received the bill from the Vendor, and whether or not the PO was received in full or not. This worked fairly well, for awhile, but now it’s driving me insane! Is there anyway that I can get rid of my spreadsheets and track the job and cost codes for my Purchase Orders in QuickBooks? Continue reading
Creating Estimates In Excel vs. QuickBooks – What’s the Difference?
If you use QuickBooks for your accounting and you create your Estimates in Excel instead of within QuickBooks {which does provide you with an Estimating feature} you loose out on job costing capabilities and so much more! Continue reading
#Freebie Friday – 100 Essential Tips for Microsoft Office 2010
Most of us use Office, and most of us could make better use of it, too. Check out these tips, sorted by application to learn basic tricks and advanced tips for Word, Excel, PowerPoint, Outlook, and Access. Continue reading
Freebie Friday – Microsoft Office 2010 Ultimate Tips & Tricks
From MakeUseOf.com - Microsoft Office 2010: Ultimate Tips & Tricks. A must have for anyone using the latest version of Office or those planning an upgrade. Continue reading
Texas Department of Transportation Requires Electronic Certified Payrolls (E-Payrolls)
The Texas Department of Transportation, like many other state agencies, is requiring electronic submission of certified payroll reports, through its Electronic Project Records System (EPRS).
TxDOT EPRS provides contractors with multiple functions which they can utilize; however, one of the… Continue reading