This article aims to support your accountancy routines. By consistently completing all tasks outlined here, you can maintain accurate accounts. If you need clarification on any steps, please reach out to support for assistance.
Tips and recommendations
Get used to using the search function (Alt+Q) instead of the menu to navigate around the accountancy system.
If a customer has paid via a bank transfer, we strongly recommend that you apply the payment only whilst performing a Payment Reconciliation Journal and to avoid applying the payment manually. This greatly reduces the chance of duplicating transactions on your bank account.
Watch this video to learn how to add new G/L Accounts (Nominal Codes) Video.
Daily Routines
These tasks should ideally be completed daily; if possible, the reconciliation should be done on the same day. Some of these processes relate to the general use of the service side of Garage Hive.
Post Jobsheets (Retail customers).
Post Jobsheets (Account customers with payment terms).
Run the WIP report (Reports -> End of Day -> Jobsheets - Work in Progress) and make sure all the necessary Jobsheets are posted or deleted.
Post Parts Purchase Invoices.
Items to return report checked (Reports -> Additional -> Items to Return) - Video.
Return Items added to Purchase Return Orders - Video.
Post Parts Purchase Credit Memos.
Daily Reconciliation
Your daily reconciliation is the most important aspect of your accountancy process. If your end-of-day process is strict and the reconciliation is accurate, the rest of your accountancy process will be much easier.
We recommend having a separate folder for each day of the week. During the day, each posted purchase invoice should be placed in this folder. This is also useful for separating the posted purchase invoices from those that still need posting.
For an accurate daily reconciliation, the following must be complete:
Reconcile End of Day Report (Reports -> End of Day -> End of Day Report):
Reconcile customer receipts/refunds:
Run PDQ/Card Receipt at the end of the day.
Check till float/cash receipts.
Reconcile Posted Purchase invoices:
Check Vendor No, Document No, Document date, & Amounts are correct on the End of Day Report.
Note: If you have taken account payments and posted them, you need to run an additional report for the end-of-day reconciliation.
At the end of each day, you should have the following in your “End of Day” folder for that day.
End of Day Report
Customer Payment/Till Report (If required)
Posted Purchase Invoices (Posted that day)
PDQ End of day report
Card Receipts
Cash taken that day (If safe to do so)
This “End of Day” folder should then be passed to the person responsible for your bookkeeping/accounting to double-check and file.
Weekly Routines
Post Business Purchase Invoices (Utilities, etc) - Video.
Check any outstanding purchase orders that are over a week old.
Check any outstanding Purchase Return Orders over a week old.
Bank reconciliation / Payment reconciliation journal (this can also be done daily) - Video.
Check your bank balances are correct—Use the search function and search for “Bank Account.” Select the relevant bank account, and in the action bar, select Navigate -> Balance. Select the desired “View by” and “View as” options as necessary. If there is a difference, identify which date the difference occurred and select the balance figure. This will open the bank ledger entries related to that day for you to analyse.
Check debit/credit clearing and till G/L Accounts are correct on the Trial Balance - Video.
Monthly Routines
Bank reconciliation / Payment reconciliation journal (this should have been done weekly; make sure the month is completely posted) - Video.
Check your bank balances are correct—Use the search function and search for “Bank Account.” Select the relevant bank account, and in the action bar, select Navigate -> Balance. Select the desired “View by” and “View as” options as necessary. If there is a difference, identify which date the difference occurred and select the balance figure. This will open the bank ledger entries related to that day.
Check any outstanding purchase orders that are over a month old.
Check any outstanding Purchase Return Orders over a month old.