Reconciliation is one of the accounting tasks used to perform a comparison of two financial records to verify the accuracy of their figures. This feature in Sage 50 is used by a small organization to explain the figure difference between the two accounts and also check the consistency. The company owners usually reconcile their accounts daily or monthly. In Sage 50, the bank Reconcile option is there to match the two bank transactions that filled in it. The main objective of this topic is to discuss on Sage 50 Reconcile Bank Account and its related content. Also ReConcileBooks gives insights of Sage 50 Bank Reconciliation which helps you.
Sage bank accounts transaction must match with the actual bank account to display the correct bank balance. Thus, helps in effective cash flow management. Reconcile option within bank permit you match every transaction in Sage account to the bank statements.
Before you start Sage 50 Reconcile Bank Account, you have to guarantee that you have filled most of your financial transactions for the duration that you are reconciling. Generally, accountants or bookkeepers would reconcile the bank balance towards the finishing date of every month, when they get their bank statements. Now, this task is easier through reconciling account via Sage50 daily, weekly or monthly. Also ReConcileBooks full details about How To Reconcile Credit Card in Sage 50.
Sage 50 Reconcile Bank Account Process
Step By Step to Reconcile Accounts in Sage 50?
Locate Menu bar, choose Tasks and then choose Account Reconciliation
Search Drop-down named Account to Reconcile; choose the ID associated with the preferred account to reconcile
Write the statement date written in account statement into the field named Statement Date
Now, write the accounts balance into the field which says Statement Ending Balance
After this entire chosen account’s transactions display in a list along with bank credits and deposits
To modify the items listed in the transaction drop-down menu named Show located at the top of the dialog box
This information is then used to reconcile the account in Sage 50 along with bank account transactions. It is done by selecting the transactions that display within the statement marked as cleared.
Now you clear entire Sage 50 transactions then the reconciled difference appears at the bottom of the dialog box approaches zero. Once you marked complete cleared transactions then the difference must be 0.
If you want to fill bank service fees and earned interest in the reconciliation wizard, you have to hit on the Expand button located in the left corner. This also expands the section named service charges if required
Fill any interest income or service charges into the boxes with identical names as in the section
Ensure that you enter the accurate date of the transaction and the linked account to monitor their value, such as an earned interest income account or bank service fees.
Verify the checkbox with cleared transactions to clear the displaying transactions
Hit on OK option to save the changes and for closing the window
If you want to clear multiple transactions then locate Multiple options located in the toolbar
This will display a dialog box named clear transactions
Choose the preferred transaction listed in the dropdown which says Type
Then choose whether to clear the transactions depending upon the Date Range or Reference Number
Write the range of reference numbers to mark the chosen cleared type
Hit on OK to clear
In case you need to link bank transaction to account via Sage Bank Feeds, Hit the Bank Feed options located in the toolbar
Choose the command named Connect to Bank Feed command to display the Sage Bank Feeds page
You need to write and confirm email address and after that accept the terms and conditions to proceed
Follow the on-screen instructions in the window to authenticate yourself and also to get access for your bank’s online account box
For importing a bank statement copy to perform matching of transactions, you need to hit on import option located in the toolbar
This will display the Import Statement window
For this, ensure that you have already downloaded a bank statement copy from associated Bank website
Now hit on Browse option to display a dialog box to open the statement file
Choose import option to open a window named Select Account Window
Click on the account that you want to import
If you want to view reconciliation reports then you need to locate the Report option in the toolbar
Choose the report to display
There is also a drop-down named clear in the toolbar to choose to check All or Uncheck All
To write new transactions that alter the account reconciliation, hit on Add New option to display Drop-down option
Choose either Write Check, Receipt, General Journal Entry or Account Register to open their related window
Write additional transactions if required
For new Sage 50 users, they have to hit on Beginning Transactions appearing in gray arrow option located in the right corner of Service Charges tab to display the Beginning Transactions window when expanded
You can fill the transaction that encountered before the beginning date of the Sage 50 company file. These entered transactions are used for account reconciliation. This will not impact the General account.
Locate Bank accounts and click on the preferred bank account
Hit on Reconcile and write Ending Balance as written on bank statement
Write statement Date
Write interest earned along with Date
Fill Account Charges & Date
Hit on OK
Help Sage 50 Pro, Premium , Quantum Bank Reconciliation Errors
The above-described information is enough for Sage 50 Reconcile Bank Account for maintaining the accuracy and consistency of financial accounts. To explore more or have any questions, you need to reach the +1347-967-4079 Toll Free Number ReConcileBooks. The Sage 50 Support professionals are glad to address all your queries and provide you all answers to your question and errors. You can also ask your suggestions via email ReConcileBooks or do a live chat with Sage 50 experts and resolve all your glitches without any delays.