A Beginners Guide to Bank Reconciliation in Sunrise

A Beginner's Guide to Bank Reconciliation

A Beginner's Guide to Bank Reconciliation

Bank Reconciliation 

Bank reconciliation is the process to ensure that your accounting software and your bank account match (equal) on a specific transaction period (usually a month or a year). The goal of reconciliation is to make sure you have an accurate representation between the transactions in your bookkeeping software and the transactions listed in your bank account.

Sunrise lets you review the differences and spot what might be inaccurate if they’re not matching up. 

Note: This guide assumes you’ve already synced your bank accounts and recorded expenses for the period you’re reviewing. If you haven’t, you’ll need to do that before reconciling. Here’s how to do it.

Step 1: Go to your bank account.

After logging into Sunrise, on the left-hand column, click on the link to Bank accounts:

Step 2: Visit your account balance

Select Account Balance on the upper right-hand side. Depending on your settings, you may skip this step and jump right to Step 3.

Step 3: Spotting differences by month or year

Use the data filter to check, month-by-month, that your account balance in Sunrise matches the account balances shown in your bank statements

Pick the same date range in Sunrise as you get from your bank transactions:

What to do If they’re not matching

Step 1: Note the difference

Subtract the balance in Sunrise from the balance shown in your bank account or bank statement.

This difference is what we’re going to track down as it's likely one or more transactions from your bank never made it into Sunrise.

Step 2: Find the transaction(s) that total this difference. 

Let’s say, for our example, the difference is $500.  Either you’ve got a duplicate, an errant transaction (maybe a typo when you entered it)? Or are missing one. It’s one of those three or a combination.

Go line by line between your transactions in Sunrise and the transactions in your bank account until you spot the one(s) that add up to the difference.

Pro Tip: It often helps to download both transaction lists as CSVs, one from Sunrise and one from your Bank, so that you can match them in a spreadsheet. Then you can eliminate transactions that Sunrise has captured, leaving behind the ones that were not imported into Sunrise. 

Step 3: Check your manual transactions – the amounts may vary if you’re inputting transactions manually. 

Typos happen, and it can be as simple as that. Most times, the bank gets it right, so pay attention to the transactions you’ve entered manually.

Step 4: Upload a CSV with the missing transactions

Once you have identified the missing transactions, you can put them into a CSV file with Date, Description, and Amount headers and upload them into Sunrise. 

Further Trouble Shooting: tips transactions don’t match

Triple check manual transactions

The bank account sync to only accounts for what’s in your bank. If someone is paying you in cash or activity outside of your bank, you’ll want to manually add those transactions. You can manually enter the missing transaction if this is the case. 

Turn to an expert

Reconciliation is a time-consuming task. Sunrise has professional bookkeepers available to solve this and loads of other tasks. You can easily hire one here.

Check bank fees/Interest.

Occasionally these aren’t listed as a transaction, so if you’ve made interest or incurred a fee, double-check that it’s included.

Review deposits

You may have received a payment/check from a customer but not deposited it. Good to spot check those.

Pro tip: Sometimes, the difference in totals is more than one entry. Look for two or more totals that add up to the $500 you’re missing. 

    • Related Articles

    • A Beginner’s Guide to Bank Reconciliation

      The term “bank reconciliation” refers to matching the bank account feed in your Lendio account, with your actual bank account over a certain period of time. This is an important process to perform to ensure the accuracy of the transactions within ...
    • How to: Connect Your Bank Account on the Mobile App

      The true power of Sunrise comes into play when you add a business bank account. Doing so allows you to pull in your transactions, keeping your bank feed automatically updated and providing access to financial health reports. This also allows you to ...
    • Issues Syncing My Bank Account

      Overview The following situations are some common issues encountered & how to troubleshoot them.  Invalid Credentials Your financial institution has indicated that the credentials provided are invalid. Verify that you’re selecting the correct ...
    • How can I change which bank account my payments are deposited?

      How can I change which bank account my payments are deposited? You can change the bank account your Sunrise Pay sends money to in just a few easy steps. Click on Payments Sign in to your merchant account Click the three lines button at the top to ...
    • How does my customer make a payment through a bank transfer?

      A simple solution for bank transfers with Sunrise Pay Receiving payments via direct bank transfer is significantly less expensive than using credit cards, but getting users signed in and authenticated can be a cumbersome process.  Sunrise Pay makes ...