Bank Journal and GL Report do not match

Issue:  Bank Journal Balance and GL Bank Balance amount have a discrepancy.  Can you tell me why? 

I need assistance in correcting the discrepancy for the calculated bank journal balance and the GL bank balance amount. 

First:  Check to see if there are Journal Entries for that time period.  Journal Entries will update the GL but it will not show up on the reports.  FINANCIALS -> GENERAL JOURNAL TAB 

If there are no Journal Entries start narrowing down the transactions in the Bank Journal and the GL Report.   

Start running your reports from the first day of conversion to Soluno (or at least run the reports for a time when they both were the same value).   

Check the base amounts from the converted data to eliminate errors from the start:   

REPORTS -> BANKING -> OPERATING (OR TRUST) TAB. 

Run the Bank Journal with the “End Date” set to the date of Soluno Conversion (ex. Dec 31st, 2018). 

The top part of the report will show the Opening Balance entry.  The middle part will show converted transactions (which will be shown as positive and negative amounts, so they do not impact the GL).  The bottom of the report will show the Summary and the Closing amount as of the end date.  This should match the Opening Balance amount. 

Side note: If these amounts are not the same: check the closing Trial Balance amount from the previous software for this GL Account, and make sure that amount has been entered into the Opening Balance tab in Soluno.  FINANCIALS -> OPENING BALANCE TAB. 

In this example the Opening Balance and Closing Balance match.   

Therefore, the starting amounts from conversion are correct.  The out of balance amount error must be between the start date and today’s date.   

The best approach, from this point, is to run the Bank Journal for today’s date and run the GL report for today’s date.  If they are not the same, continue to run these reports by splitting the months in half, backward and forward, until the Bank Journal and the GL Report have fewer and fewer transactions to view, and you are able to close in on the issue causing the problem. 

Example:  conversion date was Dec 31st, today’s date is October 31st.  Amounts no longer match. 

Run the Bank Journal and the GL Report for the Conversion Date (Set Start Date to Dec 31st, don't put any End Date).  The amounts match and the GL Opening Balance is correct.

Therefore, the two reports need to be run with Start Date today (Oct 31st) and End Date Dec 31st (Conversion Date).  To pinpoint when they got of sync. 

Run the Bank Journal and the GL report for today’s date.  They do not match. 

Split the months in half.  Run the Bank Journal and the GL report for December 31st to May 31st. 

If they match, then the problem happened after May 31st.  Somewhere between May 31st and October 31st; therefore, split those months and run the reports for May 31st to August 15th.  

If they don’t match, then the problem happened before August 15th and after May 31st. 

Keep splitting the months in this way.  As soon as you find a month where the reports are off, run the reports in shorter periods within that month until you can find the transaction that may be causing the out of balance error.  Please