Schedule an audit on the 1st of the month, BEFORE invoices have been sent.
QUICKBOOKS - ACCOUNTS RECEIVABLE AGING SUMMARY
- Log into QuickBooks
- Under 'REPORTS' run the Accounts receivable aging summary
- Ensure report 'as of - end of month' date has been adjusted
- Export as PDF
- Save to folder - V:\Accounting - QBO Backups and Reports\Monthly Receivable Audit Reports as: YYYY.MM.DD_QBO report
HARVEST - ACCOUNTS RECEIVABLE AGING SUMMARY
- Log into Harvest
- Under INVOICES tab, select REPORT subcategory
- Select 'NEW REPORT'
- If needed adjust 'timeframe'
- Under 'status' only select 'SENT' and 'LATE'
- Print to PDF.
- I would not export as PDF as Harvest exports the individual invoices instead of the a report.
- Save to folder - V:\Accounting - QBO Backups and Reports\Monthly Receivable Audit Reports as: YYYY.MM.DD_Harvest report
HARVEST - RETAINER AMOUNT
- Log into Harvest
- Under INVOICES tab, select Retainers subcategory
- Note the 'Retainer Balance Amount'
- Print to PDF
- If the Abacist numbers do not match check the following:
1) Ensure retainer amount was transferred over from Checkings to Savings each time a retainer amount was used
2) Ensure each incoming retainer check was deposited to Checkings
MONTHLY RECEIVABLES AUDIT REPORT
- Update the monthly receivables audit report, saved to folder: V:\Accounting - QBO Backups and Reports\Monthly Receivable Audit Reports
Do the numbers match? If they don't, put on your detective hat! If they do, sit back and marvel at the incredible job you are doing :-)