USA Balance sheet


Joined
Mar 30, 2016
Messages
2
Reaction score
0
Country
United States
If this balance sheet is off by a negative number one month and then off the next month by the same number but now it's positive, what do you think the issue is and where should I look to figure out where the issue is stemming from?
 
Ad

Advertisements

kirby

VIP Member
Joined
May 12, 2011
Messages
2,357
Reaction score
323
Country
United States
Hi
Sounds like one side of the double entry has an effective date in the future. So look at your entries (particularly general journal entries) in the affected month.
Example

Balance sheet for Feb shows Assets $100,000 and Liab and OE = $110,000
Reason:
Journal entry posted in Feb DR Cash $10,000 effective date MARCH 1, 2016, CR Accts Payable $10,000 effective date Feb 29, 2016.
Most systems will force the entry into balance but not all will.


.
 
Joined
Mar 30, 2016
Messages
2
Reaction score
0
Country
United States
Hmmm. How could that happen if the DR & CR is done in the same journal entry with one date?
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,357
Reaction score
323
Country
United States
In THEORY no way. Yet in REALITY there you are with this problem. Look at the effective (not posting) dates and be sure. Run a query to find where posting month of Feb 2016 is not equal to effective month and look at those guys.
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,357
Reaction score
323
Country
United States
Also maybe a new acct was used but not added to the balance sheet. This can happen with some gl systems
 
Ad

Advertisements

kirby

VIP Member
Joined
May 12, 2011
Messages
2,357
Reaction score
323
Country
United States
One more tool. Run a daily balance sheet report starting from your last date you were in balance every day until you hit the date where you are out of balance. That will tell you the posting date that is causing the error. Review all the postings for that date
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

balancing of Balance Sheet 1
Balance Sheet 5
balance sheet 1
Balance Sheet 2
Balance Sheet 0
Balance Sheet 2
Balance sheet 2
Italy Balance Sheet 1

Top