Browse
 
Tools
Categories

How to fix an unbalanced Balance Sheet

Author: support staff Reference Number: AA-01271 Created: 2011-02-22 01:05 Last Updated: 2013-11-18 21:19 0 Rating/ Voters

Technically, OneSource has been designed to not allow postings to your GL unless the debits and credits balance.  However, with the proper security permissions, OneSource tables can be directly accessed and individual debits and or credits can be changed in the GL Transactions table and/or the View Posted GL Transactions form.

If at any time your GL becomes unbalanced please follow these steps to find and correct the problem.

  • Run the General Journal - Transactions Summary report. This report displays a total of the debits and credits for each complete day.  Be sure to run this report for a wide date range to make sure all debits and credits are included, such as 1/1/00 through 1/1/2099.  If you preview the results of the report on your PC screen, you will be able to scroll through each day looking for any days that show a difference displayed in red. Make a note of each day that shows a difference between the amount that was debited vs. credited to the GL on that day.
  • Next, run the General Journal - Transactions Summary - Detailed report for each individual day that you noted from the first report.  (For example, if 3/5/04 has a problem, enter From Date: 3/5/04 and To Date: 3/5/04 on the Report Selection Screen before running the report).  Scan through the transactions looking for any transactions that do not balance.  
  • After you have identified the dates and transactions that have a problem, the next step will be to correct the problems.  This may require a manual change to be made in the GL Transactions table and/or the use of the Batch Unpost GL Transactions tool.  If the solution is not fairly obvious, please contact OneSource for additional support to help resolve the problem.