\n
![](\"https:\/\/images.squarespace-cdn.com\/content\/v1\/509ed143e4b001bf11102ee6\/1627069304321-8RWN6UOHB2DFTOT0355R\/unsplash-image-3ROwc3JSjCk.jpg?format=1500w\")
<\/p>\n
\n<\/p>\n
A bank reconciliation (or bank rec as it is commonly known) is a process whereby you ensure that the transactions on your bank statement (the monthly statement that you receive directly from your bank) match the transactions that you have recorded in your accounting.\u00a0 <\/p>\n
It involves checking each transaction on the bank or credit card statement and ensuring that it appears in your books and vice versa.\u00a0 Any discrepancies between the bank statements and your books must then be resolved<\/strong>.\u00a0 <\/p>\n A bank reconciliation is essential to ensure that the bank balance in your books is correct and that all transactions that pass through the bank are recorded.\u00a0 The process helps to identify missing transactions, errors and omissions and to ensure that your accounting is accurate and complete. \u00a0Without a bank reconciliation i.e. a verification that the bank balance matches the books, it would be very easy to erroneously record or even make up bank transactions thereby rendering your financial reports inaccurate and ultimately, meaningless.\u00a0 \u00a0<\/p>\n Accounting software will often have differences between the bank statement and the bank balance due to transactions such as cheques issued and deposits received that are still in transit.\u00a0 Eg. When you give someone a cheque they may take a few days (or months) to cash it.\u00a0 This will be referred to as an \u201coutstanding\u201d transaction on the bank reconciliation and will remain unchecked until the cheque is actually cashed. This is not an error, but simply a difference that is identified through the process of doing a bank reconciliation. <\/p>\n There are various types of differences and discrepancies that a bank reconciliation can uncover some of which include:<\/p>\n Outstanding cheques that have not yet been cashed<\/p>\n<\/li>\n Deposits in transit i.e. deposit that might be made on the last day of the month but only appear on the next bank statement<\/p>\n<\/li>\n Bank charges such as monthly fees, per transaction charges, e-transfer fees etc. that you only see once you receive your monthly bank statement<\/p>\n<\/li>\n Interest expenses such as overdraft interest, credit card interest and interest on loans that also are not know until the bank statement is received<\/p>\n<\/li>\n Monthly credit card fees <\/p>\n<\/li>\n Transactions amounts that are incorrect <\/p>\n<\/li>\n Transactions that have not been entered (missing transactions)<\/p>\n<\/li>\n Transfers between accounts such as payments to the credit card accounts, loan payments and withdrawals by the owner\/shareholder or repayments)<\/p>\n<\/li>\n Bank errors <\/p>\n<\/li>\n<\/ul>\n Typically a bank reconciliation is done monthly since banks send monthly statements.\u00a0 However, these days online banking allows you to retrieve your bank details anytime you want so you if \u00a0you have numerous transactions , you can also do it more frequently.\u00a0 <\/p>\n Although at least monthly is recommended for those who do their own bank reconciliations, it is not uncommon for very small businesses\/self employed owners to do them quarterly or even annually before they hand over their accounting to their accountants<\/p>\n This assumes that <\/em><\/p>\n you have a separate and dedicated bank account for your business, which every business owner should have. However, if you don\u2019t have a separate bank account, then a bank reconciliation might simply involve reviewing your business related bank transactions for the month and ensuring that you have reflected them in your books or your spreadsheet. <\/em><\/p>\n<\/li>\n You are using accounting software with a bank reconciliation module<\/em><\/p>\n<\/li>\n<\/ol>\n A bank reconciliation is a straightforward process but requires meticulous attention to detail. \u00a0Since you are comparing numbers, you need to make sure that each number corresponds exactly.\u00a0 <\/p>\n To do a typical bank reconciliation you need the bank statement and the detailed balance in your bank account from your books (often referred to as a cash subledger or a cash register). <\/p>\n You will need the following information from your bank statement as a starting point<\/p>\n Opening balance per the bank statement<\/p>\n<\/li>\n Closing balance per the bank statement<\/p>\n<\/li>\n Date range of the bank statement<\/p>\n<\/li>\n<\/ul>\n Most accounting software will provide you with a reconciliation interface where you enter the details above and then check off each transaction in the books against the transactions in the bank statement.\u00a0 \u00a0The transactions that then appear on one but not the other need to be reviewed and entered, if applicable, and any discrepancies need to be corrected. <\/p>\n For example, you might only enter your bank charges or transfers between accounts at the end of the month when you are doing your bank reconciliation.\u00a0 It is important to note that if the process is followed, and all transactions from the bank statement are entered and checked off, you bank balance will always reconcile.\u00a0 However, even if it does reconcile you may still be left with unresolved transactions that have to be reviewed,<\/p>\n Luckily accounting software has made the process significantly easier as many of these software such as Quickbooks Online<\/a> and Xero download the transactions automatically (once you link your accounts) and also match the transactions that have been entered.\u00a0 This leaves you only with unmatched transactions to resolve.<\/p>\n \u00a0In the banking section of Quickbooks Online<\/a> you will notice a \u201cbank balance\u201d amount and \u201camount in Quickbooks\u201d for each account which has been \u201clinked\u201d and is automatically downloaded transactions.\u00a0 When all of the downloaded transactions have been entered, these amounts should be identical.\u00a0 If not, it likely means that there are unresolved transactions.\u00a0 (the other possible for the difference between the bank balance and in Quickbooks amounts are that the latest transactions have not yet been downloaded but the balance has been updated)<\/p>\n To reconcile your account in QBO,\u00a0 go to \u201creconcile\u201d which can be found by going to the \u201caccounting\u201d tab on the left hand side.\u00a0 This will bring up the reconciliation interface where you would enter the ending balance from the statement and the statement date.\u00a0 Once done, it will take you to the actual reconciliation where all transactions that\u00a0 have been downloaded and entered will be automatically matched.\u00a0 Your job is to go in and determine why some transactions are not matched and how to fix them.\u00a0 Some of the possible errors include:<\/p>\n Outstanding cheques which have not yet been cashed.\u00a0 Nothing needs to be done, unless they are very old in which case they should be written off.<\/p>\n<\/li>\n Duplicate deposits or payments.\u00a0 The solution to this is to determine why these were entered twice and ensure that the correct one is selected and properly applied to the invoice or bill.<\/p>\n<\/li>\n Transfers to and from other accounts that are duplicated.\u00a0 These should be reviewed in the same way as above.\u00a0 <\/p>\n<\/li>\n Multicurrency transfers that use the QBO rate instead of the bank rate.\u00a0 In this case, you can simply change the rate on the transaction to match the bank rate.<\/p>\n<\/li>\n Differences in payment or deposit amounts (often by just 1 or 2 cents) that need to be adjusted to match the bank.\u00a0 Alternatively, if the discrepancies are very small you can enter them as bank charges.\u00a0<\/p>\n<\/li>\n<\/ul>\n Once everything matches and any differences have been resolved, you would click on \u201cFinish Now\u201d which can be found on the top right dropdown (\u201cSave for Later).\u00a0 Finishing the bank reconciliation records it as having been reconciled in the system and any inadvertent changes in the future to the bank reconciliation can then be easily identified by going to the \u201chistory by account\u201d which shows you changes to the bank transactions after you have done the reconciliation. <\/p>\n Doing a regular bank reconciliation is a key accounting function to ensure the integrity of your accounting and reports.\u00a0 If you\u2019re a bit of numbers nerd like me or if you like things organized, it can also be quite satisfying to do.<\/p>\n For more about information regarding our <\/em><\/strong>products, services and articles relating to QuickBooks<\/em><\/strong><\/a>, please refer to our <\/em><\/strong>QuickBooks <\/em><\/strong><\/a>page.<\/em><\/strong><\/p>\n<\/div>\nWhy do you need a bank reconciliation?<\/strong><\/h2>\n
What types of differences does a bank reconciliation uncover?<\/strong><\/h2>\n
\n
How often do you need to do a bank reconciliation ?<\/strong><\/h2>\n
How do you do a bank reconciliation?<\/strong><\/h2>\n
\n
\n
How do you do a bank reconciliation in Quickbooks Online ?<\/strong><\/h2>\n
\n