A Beginner’s Guide to Bank Reconciliation in Sunrise

A Beginner’s Guide to Bank Reconciliation in Sunrise

The term “bank reconciliation” refers to matching the balance of your Sunrise bank account feed to that of 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 your instance of Sunrise so that any accounting actions performed are sourced from correct data. If the two numbers don’t match, then some error was made.


For example, let’s say your bank statement shows a balance of $10,000 at the end of October. Meanwhile, your Sunrise feed shows a balance of just $8,000. Considering your bank statement is the ultimate arbiter of truth, your Sunrise bank feed should be reconciled to correct any missing transactions.

Why might my Sunrise bank feed not match my bank statement?


There can be a variety of reasons for discrepancies between your Sunrise feed and your bank statement. Reasons include:


  • Manually entered transactions caused duplications

  • Reversed/Refunded transactions weren’t correctly processed

  • Outstanding transactions from older periods changed older balances

  • Missing transactions from the bank feed didn’t import


No matter how diligent you are, discrepancies can creep in. Sunrise has made it easy to reconcile your feed so you can rest assured that your accounting is always working from correct data. Let’s look at how to use our Period Reconciliation Tool (PRT) for this purpose.

Period Reconciliation

Here’s how to reconcile your Sunrise bank feed with your bank statement with a simple to use tool.


Step 1: Have your bank statement handy

Since you’ll be squaring up your Sunrise bank feed numbers with your actual bank account, you’ll need to have your bank statement ready to view. So log into your bank and download the statement from the month you are trying to balance. 


Step 2: Go to “Reconcile Accounts” in your Sunrise bank feed


After logging into Sunrise, click “Bank Accounts” on the left navigation.



To the right of your bank account feed, you’ll see a folder icon on the right-hand slider.


Clicking this will open the slide as well as Sunrise’s tool to reconcile accounts as seen below.



Step 3: Fill in the Reconciliation Period prompts


The first time you reconcile using this tool, you will be prompted to define your start and end date as well as your beginning and ending balances from your bank statement (for your chosen period).




Once your information is filled in, click “Reconcile Period.” You’ll immediately see whether your Sunrise bank feed matches with the balances you just entered in from your bank statement.


If the balances match, this period is now reconciled. You now are assured that your Sunrise bank feed and your bank statement are mirrored for this time period.


Reconciled periods will be grouped together in folders named after the end date. These folders can be found at the bottom of your Sunrise bank feed.



Key Benefit of the Folder Method:


The benefit of having these folders is to show you precisely which periods you have already reconciled. Now you have quick access to a date range that you know matches up to your bank statement. These folders will always be at the bottom of your list of bank transactions.

You can expand each folder to see the transactions there using the arrow on the right hand side on each folder line, as well as click “Undo Period” to un-reconcile this date range. You may want to undo the reconciliation if your bank statement changes, which is a rare occurrence.




One important note: if you undo a reconciled period, every subsequent period will also be undone. This is to ensure no erroneous transactions can be carried over to the next time periods.

What if my feed doesn’t reconcile?

If, after using the Period Reconciliation tool, you find that your Sunrise bank feed balance doesn’t match your bank statement, we have provided an easy way to fix that as well, using our Bank Feed Corrections tool.


This feature lets you import a CSV file from your bank and upload it directly into your Sunrise bank feed. This will automatically find any discrepancies and tell you which transactions are either missing or duplicated, as well as giving you the option to easily correct these errors.


Here’s how the tool works.


Step 1: Open the Bank Feed Corrections tool


If you use the Reconcile Period tool and there are discrepancies, you will be given the option to use the Bank Feed Corrections tool. You can also use this at any time by selecting it from the “More” menu in the upper right.



Step 2: Upload a CSV version of your bank statement


The next screen will prompt you to upload a CSV of your bank statement, which you can download from your bank’s website.



Once uploaded, the tool will prompt you to map the column headers and log the date range of the bank statement you just uploaded.

Step 3: Review and apply proposed changes


Next, the Bank Feed Corrections tool will display a summary of the proposed changes for you to approve.




Click on “View Corrections” and the tool will offer to fix these discrepancies by importing any missing transactions. You’ll see checkboxes so you can manually skip any corrections you don’t want in your Sunrise bank account feed.



Usually, you’ll leave all proposed changes checked and then click “Import Entries” to apply these changes to your Sunrise account.

On the next step, the tool will prompt you to remove any duplicate transactions from Sunrise. Again, you will have checkboxes to manually skip any entries you don’t want to change in your Sunrise bank account feed.




Click “Delete Entries” to apply changes.



You’re all set! The next screen will provide a summary of the updates that have been made to your Sunrise account via the Bank Feed Corrections tool.



Congratulations!

To learn even more about reconciliation, check out our blog post on the topic here.

    • Related Articles

    • 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 ...
    • Link Your Bank Account

      The best way to track your transactions and reconcile your account is to link your bank account. After that, Sunrise does a lot of the heavy lifting so you have more time to focus on your business.   Our integration with Finicity allows you to ...
    • How do I verify my bank with a Sunrise Pay merchant account?

      How do I verify my bank account? To verify your account with Sunrise Pay, please log into your merchant account by clicking on "Payments" and logging into WePay's Merchant Portal. Once logged in, click your name at the top of your homepage. From ...
    • 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 ...
    • Common Bank Sync Issues via Plaid

      The following steps will help you troubleshoot issues you may encounter with your bank connection via Plaid. If your specific concern is not addressed in this document, please reach out to the support team: support@sunriseapp.com. Invalid Credentials ...