Bank reconciliation

A bank reconciliation is used to check bank transactions in Brightpearl against the real bank statement.

This ensures every deposit or withdrawal in the bank account is also processed in Brightpearl and that the values match exactly.

Reconciling a bank account

The reconciliation process allows you to input the date and balance details of the bank statement.

Brightpearl will then list all the unreconciled transactions within the statement period, as well as the previous 30 days' worth of transactions.

The process is then literally a case of checking that each and every item on the bank statement exists in Brightpearl with the exact same amount. As each item is identified it is checked off in the Brightpearl reconciliation process and the amounts are added up as you go.

Once all the statement items have been confirmed and checked off in Brightpearl, the final balance should be equal to the closing balance of the bank statement. Once the balances are equal, the statement can be closed in Brightpearl.

This locks those accounting entries, which ensures they cannot be edited after the reconciliation has been performed.

Doing this for every bank statement will ensure that your bank balances are correctly accounted for and reported. By doing this for every bank statement you will identify any discrepancies or posting errors in your accounting system early. This makes identifying the reason for discrepancies much easier to find, rather than trying to do it at the end of the year.

How to reconcile a bank account

  1. Go to Accounting > Reconcile and select the bank account to reconcile
  2. Click the Add a new statement button
  3. Enter the statement reference, start and end dates 
    • Note that the period of each statement cannot overlap.
  4. Enter the end balance
    • The start balance is automatically taken from your last reconciliation. If this is your first reconciliation enter the start balance from the statement too.
  5. Click Save
  6. You'll see the statement in the list - click Open to begin the reconciliation.

    open statement link

  7. Find each item appearing on the real bank statement and ensure the amounts are correct.
    • If the amounts match select the checkbox against the item and continue checking.
    • If the amounts don't match, make a note of the journal ID and investigate why they don't. You may need to amend the transaction amount, do a reversal or re-enter the transaction.
    • If the transaction isn't listed in Brightpearl try searching the general ledger to ensure it has been entered. If it hasn't been entered ensure that the transaction is processed then return to the bank reconciliation and save to refresh the screen. You can now select the checkbox for the item and continue.
    • If the transaction exists but isn't listed it may be dated outside of the reconciliation - by default only transactions within the statement date range and any unreconciled items 30 days prior are listed. Use the Include earlier unreconciled checkbox to widen the search.
  8. When all the bank statement items have been found and selected, the end balance for the reconciliation should match the statement end balance, resulting in zero difference. When this happens the Close statement button becomes available. To finalize and complete the reconciliation click Close statement. Once closed, the reconciliation can't be changed and the accounting entries can no longer be edited.

    statement balances

How to reconcile a foreign currency bank account

A foreign currency bank account is reconciled in the same way as a base currency bank account since each bank account and the transactions processed through the account are held in the foreign currency. 

Reconciling a credit card

A credit card reconciliation is carried out in the same way as reconciling a bank account. The only difference with a credit card is that it is debt, so when beginning the reconciliation the statement balances should be entered as negative values.

add credit card statement

Read more about credit cards here.

Handling bank reconciliation differences

When it comes to differences between your bank statement and the entries in your bank account in Brightpearl, the key is to get everything that's on your actual bank statement to be recorded in Brightpearl at the exact same amount. The statement is what has happened in the real world, so Brightpearl must show the same. Here are some tips to getting you bank reconciliation to balance:

  • If an item on the bank statement is not found in Brightpearl it will need to be entered. 
    An example might be a cash withdrawal by the business owner. This withdrawal needs to be processed as a bank payment to record the movement of money out of the bank and to the business owner. Once you have processed the transaction in Brightpearl you will be able to reconcile it.
  • If an item on the bank statement is in Brightpearl but not found on the reconciliation screen then it could be because it is dated outside of the reconciliation period.
    Use the Include earlier unreconciled checkbox in the filter to include older transactions. By default the reconciliation shows all transactions in the statement period plus any unreconciled transactions in the 30 days prior.
  • If an item on the bank statement has the incorrect value in Brightpearl the transaction will need to be edited to match.
    Clicking on the journal ID will take you straight to the journal to make corrections. You may need to cancel the entry and re-enter it if it is associated with an order. Make sure you save your changes before leaving the reconciliation screen.
  • If an item in Brightpearl is not on the bank statement it can be ignored for now.
    This indicates a transaction which has already been entered into Brightpearl but did not yet clear the bank account. It is likely to appear on your next bank statement and reconciliation.
  • If the end balances don't match there is still a difference between what has been selected on the reconciliation in Brightpearl and what appears on the bank statement.
    Ensure all values match and all bank statement items have been found in Brightpearl.

Tip: You may wish to investigate any very old unreconciled items. This could indicate that a transaction was processed through Brightpearl which never happened in the real world.

Finding unreconciled bank transactions

You can quickly see which bank accounts have unreconciled transactions on the bank accounts screen by going to Accounting > List bank accounts and looking at the bank account - if the account contains unreconciled transactions, a message will appear in red.

There's also a bank reconciliation report, which can be reached from a link on the bank accounts screen when a bank account has unreconciled transactions.

The bank account activity report will also show which of the transactions are reconciled with a green check mark on the right hand side. You can also filter the report to show just unreconciled transactions.

Bank reconciliation statement report

The bank reconciliation statement report is found at Reports > Accounting > More. It can also be accessed from the bank account List:

bank rec statement link

bank rec statement link

This report shows:

  • The current balance of the bank account in Brightpearl
  • The reconciled balance of the bank account in Brightpearl, which represents the last statement end balance
  • The outstanding (unreconciled) payments and receipts, which are the transactions which haven't cleared the bank yet
  • The expected balance at the bank, assuming all transactions have cleared both the bank and Brightpearl

Un-reconciling bank transactions

Bank transactions can be unreconciled. This might be in order to open up the accounting journal to be editable, or it might be because an item was reconciled by mistake.

If the bank statement has already been closed it is not possible to un-reconcile the single transaction - the statement must be cleared in full. This means that the full reconciliation will need to be completed again.

If the bank statement has not yet been closed, the individual item can be deselected and the statement saved.

How to un-reconcile a closed bank statement

  1. Go to Accounting > Reconcile and select the relevant bank account
  2. Locate the relevant bank statement
  3. Click the Clear all link

This reopens the statement and releases all the items reconciled to it. The journals are now available to be amended. The reconciliation will need to be redone.

FAQs - Bank Reconciliation

Why is my statement balance not the same as in Brightpearl?

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, but you have also started processing transactions for the next period - these transactions will be on a future bank statement.

Why won't the bank account reconcile?

A bank statement will only list the transactions that cleared within that period, but sometimes a payment can be processed in Brightpearl but not clear the bank account until the following period (sometimes the bank takes a few days to process the transaction) this means the transaction will appear on the next statement. When reconciling the bank account in Brightpearl this transaction will be left unreconciled until it does appear on a statement.

Why are there unreconciled items left over?

Reconciliation cannot generally be done by simply selecting all items and expecting it to balance. The aim is not to check that all the transactions in Brightpearl are on the bank statement, but the other way around - making sure all the items on the real bank statement are in Brightpearl. There will always be extra transactions in Brightpearl - ones which have been processed but didn't clear the bank account and make it onto the current statement but which will appear on a future statement.

Have more questions? Submit a request