End-of-Day Cash Entry

The End-of-Day Cash Reconciliation is really useful for recording sales and purchases that are made away from access to Brightpearl. You might be using a separate cash register, or perhaps you are out all day selling stock on a stall. Using a print out from your cash register when you return to the office you can input all your sales and purchase figures, expenses incurred and all your takings for the day. This will create all the necessary accounting entries and allow you to easily transfer takings into your bank accounts, ensuring your financial figures and reports are accurate.

Setting Up

You will need to select a nominal code as your "cash till account" and "end of day cash errors". Follow these steps to set your cash till and error accounts:

1. Go to Setup > Company > Accounting: Nominal codes.
2. Select the account in the "Cash till account" field.
3. Select the account in the "End of day cash error" field.
4. Click Save changes.

Learn how to create nominal codes

Using the EOD Cash Reconciliation

1. Go to Accounting > End of Day.
2. Today's date is entered as default, you can change this if you are entering figures for another day; perhaps you didn't have time.
3. Click Submit. This checks to make sure the date you are using hasn't already had a cash reconciliation submitted; you can only enter one per day.
4. In the Sales/Receipts tab enter the total amount received into your cash till account.
5. Enter the amounts of each type of sale you made; there is one field per nominal code setup in the sales account range (4000-4999).
6. Ensure the Total receipts = Total sales.
7. Select the Purchases/Payments tab and enter the total amount you've paid out from your cash till account.
8. Enter any purchases, expenses and overheads paid; there is one field per nominal code setup in the purchases (5000-5999), direct expenses (6000-6999) and overheads (7000-7999) ranges.
9. Ensure the Total payments = Total purchases.
10. Select the Summary/Cash tab. The start cash float is displayed, this is based on the balance on the cash till account at the start of the day. The cash received and paid out balances are calculated from your entries in the sales and purchases tabs.
11. Use the available fields below the summary to deposit your daily takings into the correct bank accounts.
12. The End Cash Float is calculated (opening float + receipts - payments - deposits to bank). If this is not the actual amount you have counted in your float you can use the Cash Error field to make any required adjustments/write-offs.
13. When the End-of-Day balance is 0 you will be able to click Close day.

When the End-of-Day reconciliation is closed the relevant accounting entries are automatically created and posted.