When you receive your bank statement it will list all the movements of money in and out of your bank account for the period, say a month. In Brightpearl you will have been processing transactions over the same period, recording the movements of money in your bank account nominal code. These entries should match up to your actual bank account. However, not all of the entries in Brightpearl will yet have cleared your bank account, or cleared the bank account for the period of the statement, like wise, items that have cleared your bank account may not yet have been recorded through Brightpearl. So you won't be able to reconcile the whole bank account nominal code every month, there will always be items outstanding that will appear on a future statement. What you are trying to do is check every item that IS on the statement is in Brightpearl.
Items are on my statement which aren't in Brightpearl
You will need to process these transactions in Brightpearl. An example might be a cash withdrawal by the business owner. You will need to process a bank payment to record the movement of money out of the bank and to the business owner. Once you have processed it you will be able to match them together.
Items are listed for the period which aren't on my bank statement?
This is fine. These items have been processed through Brightpearl but haven't yet hit your actual bank account, or at least they didn't during the period of the bank statement. They will appear on your next statement at which point you will match them on your next statement reconciliation.
I've matched the statement item to a Brightpearl transaction but the amount is different
You can only record the amount you actually received (or paid) so will have to adjust your Brightpearl transaction. For a sale or purchase you might create a credit note or you can update the journal within Accounting.
I've ticked all the items that are on my bank statement but how come there are some left over in Brightpearl?
When you begin a reconciliation you enter the start and end dates. These are used to simply narrow down the list of transactions you've posted to the bank account nominal code; you want to tick off all the items on your statement, but you don't want to have to scroll through a list of every single item that was posted over all time. You are not attempting to tick off all the items posted in the period of the statement, only the ones that have cleared your bank account. Any left over will get reconciled on a future statement when they have cleared your account. The aim is to tick off all the items that are on your bank statement. You should tick them off on the paper statement as you tick them off in Brightpearl reconciliation.
What do all these colours mean?
Saved to this statement - you have matched the statement line item with the transaction in Brightpearl by ticking the checkbox, you have also clicked Save. It can be unreconciled by unticking the checkbox.
Saved on another statement - this item falls within the same date range but it appeared on one of your earlier statements and has been reconciled already. You cannot match it again.
Reconciled - you have matched the item with the statement, saved and closed the reconciliation. You cannot match it again.
Not reconciled - the end balance you entered from your bank statement is not the same as the balance calculated by Brightpearl (opening balance plus or minus the items ticked). You cannot complete the reconciliation until it balances.
