This article will give you a basic checklist of Month-end accounting tasks that we recommend the dealership complete.
- These are recommendations only
- It is up to dealership to determine what end of month / end of financial year tasks they need to complete
- We would also suggest that you contact your accountant for their advice and guidance
| Tasks and Resources (if applicable)|
|Task: Finalise all Cash Reconciliation for the month (BP)|
Link to Resource: What is a Cash Reconciliation / How to process a Cash Reconciliation
|Task: End of Day Balancing of Cash Drawers (BP)|
Link to Resource: How to Process the End of Day Balancing of Cash Drawers
|Task: Complete Bank Reconciliation (QB)|
Link to Resource: https://quickbooks.intuit.com/tutorials/lessons/reconcile-accounts/
|Task: Complete any other reconciliations and checks within QuickBooks as required (QB)|
For example - Any General Ledger accounts that you use as Clearing accounts eg:
- BP Stocked Trade Clearing GL
- BP Lien Payout Clearing GL
- BP Deal Option Clearing GL
If you keep Store Credits - run a Store Credit Report in BP and then review the Store Credit Liability GL
Link to Resource - How to process a Store Credit on a Customer Record / How to Report on Store Credits
|Task: Review Accounts Receivable Aging report to relevant General Ledger account (QB)|
Link to Resource: How to run Accounts Receivable Aging Report
Does your Accounts Receivable Aging Report match the relevant General Ledger account?
|Task: Review Accounts Payable Aging to General Ledger account (QB)|
Link to Resource: How to run Accounts Payable Aging Report
Does your Accounts Payable Aging Report match the relevant General Ledger account?
|Task: Reconcile Unit Inventory - Run Stock Unit report in Blackpurl and then compare with the relevant General Ledger account in QuickBooks (BP/QB)|
Link to Resource: Reporting - Stock Unit Report
|Task: Reconcile Part Inventory - Run Part Inventory Valuation Report in Blackpurl and compare with the relevant General Ledger account in QuickBooks (BP/QB)|
Link to Resource: Reporting - Part Valuation Report
|Task: Reconcile Customer Order Deposits - Run a Customer Order Report in Blackpurl and note the Deposits Totals and then compare this total with the relevant General Ledger account in QuickBooks (BP/QB)|
Link to Resource: Reporting - Customer Deposits
|Task: Close Month End in QuickBooks (QB)|
Link to Resource: How to close Month end in QB Online
IMPORTANT TO NOTE:
*** As Part Valuations is a running balance, you cannot request a report for a previous date range.
The report is only as good as that day. If you want an End of Month Valuation or End of Financial Year you must run the report last thing on the last day of the month OR first thing on the first day of the new month.
*** If you have made manual journals within QuickBooks or you have manually changed an integrated transaction from Blackpurl then you will not balance out to Blackpurl