If you notice your General Ledger (G/L) is out of balance on your System Checks and Balances report, there is another report you can run to help you find where things went out of balance.

A "Generic G/L Detail" report can be set up and saved under Save Report Format.

To create the report format, open the Generic G/L Detail Report.  You can find that report from the Graphics Menu by going to the Reports page and selecting "Accounting - General Ledger" from the drop down selector.  The "Generic G/L Detail" report will be found in the list of reports presented.

Once you have found the "Generic G/L Detail" report and start it, make the following changes:

Sort Options Tab Add the "Group" sort option. Make sure the "Print totals" box is checked.
Select Options Tab Add the Select Option of "Sys Date Posted". Give a date range: Beginning with the first date you know your G/L was in balance. Ending with the first date you know your GL was not in balance.
Field Options Tab Add the "Group", "GL#", "GL name", "Net amt", "Source code", and "Sys date posted" fields.

Now save the Report Format.

Use It When You Need It

The next time your GL goes out of balance, pull this report back up and change the dates on the selected options tab to a range starting with the first date you know your G/L was in balance and ending with the first date you know your GL was not in balance.

Preview Your Report

All of your Group totals should have a zero under the Net amount.  When you find the one(s) with a value, these are transactions that put you out of balance.   You can review these transactions using the journal that corresponds with the source code, system date, and group number listed on the report and make the necessary journal entries.