This article will give you a basic checklist of Month-end accounting tasks that we recommend the dealership complete.

Please note:

  • 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