TUG Tip - AP Import Invoices

TUG Tip -- AP Import Invoices

If you haven’t taken the time to set this up, I recommend you do so now!  It took me a while to figure out the exact format but now that I have this set up, it is saves me time and keystroke errors every month.

I have an Excel Spreadsheet set up called “Import Invoices Master”. Each tab has a different purpose, the first tab being the “key”. On the key, I change the Accounting Date, Current period (2111) which is used as part of the invoice number on utility bills. 

Then on each tab, I highlight fields that need to updated, and have formulas set up for everything else that I can, i.e. invoice number for utility bills, due date, splits.

So now when I get my 20+ City of Columbia bills every month, I update the “Key”, then update the Service Date (once) and change the dollar amount of each invoice. That’s it. Any splits, and tenant charges are handled by formulas.

I “Save As” a CVS, close, jump to Sage and Import. Post.  Done!  
I have one tab set up for our Loan Payments, same thing, although on that one I just have to update the interest or principal amount for each payment. The highlighted fields:

I feel it is well worth the time to learn if you have a lot of the same type of invoices every month like I do, or a lot of loan payments every month.

Good Luck!