Topic Options
#41429 - 05/06/14 10:09 AM Trial Balances
Clint Offline
Adagio Fan

Registered: 07/15/13
Posts: 38
Loc: Seattle, Washington
Hi Everyone,

Our CPA would like to see a Trial Balance from Dec 31, 2012 and Jan 1, 2013. I have tried to run the report out of the GL (i.e. Reports>Trial Balance). When we run the report there is no option to change the specific day so we are stuck looking at the end of the month for each period. I have check the box that says "include opening balances" but the report is no different than not checking the box.

Thanks

Clint

Top
#41430 - 05/06/14 10:27 AM Re: Trial Balances [Re: Clint]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4510
Loc: Wynnewood, PA
Hi Clint

If your year-end is Dec 31, then there is no real difference between the two reports, except that for the Jan 1 trial balance all of the income and expense accounts will have a zero balance, and the Retained Earnings account will be higher by the net income of the prior year. That's easy enough to adjust in Excel after exporting the Dec 31 trial balance to Excel.

Steve

Top
#41431 - 05/06/14 10:48 AM Re: Trial Balances [Re: Steve Schwartz]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
For the opening report, select the "Opening balances for the period." option for the report an choose period 1.

There's no need to go to Excel.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Douglas Dickie), 73 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14464 Topics
70649 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30