We are having a real tough time with the financial side of the software. Right now our bookeeper is trying to close out the month but there isn't a Trial Balance Detail report in the system. We can't even use the Excel addin to produce one. What is the workaround?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trial Balance Detail Report
- Thread starter GSpreeman
- Start date
What version of Macola? You should never ask a question without this information.
There is a Trial Balance Crystal Report at GL\Reports\Reports\Trial Balance. You'll have to click on the "details" checkbox to get details.
The Excel addin also provides a Trial Balance that is broken out between a balance sheet and an income statement on different tabs of a single Excel workbook.
When you say "We can't even use the Excel addin to produce one" are you saying this report does not generate? If so what error(s) are you getting?
Or are you saying the report is not in the format you would like it to be in?
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
There is a Trial Balance Crystal Report at GL\Reports\Reports\Trial Balance. You'll have to click on the "details" checkbox to get details.
The Excel addin also provides a Trial Balance that is broken out between a balance sheet and an income statement on different tabs of a single Excel workbook.
When you say "We can't even use the Excel addin to produce one" are you saying this report does not generate? If so what error(s) are you getting?
Or are you saying the report is not in the format you would like it to be in?
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Thread starter
- #3
Version 4.0.0.324
Release 372
One problem is that when we produce the report with details, it gives us all the ins and outs. If we had offsetting transactions where we credited $150 and debited $150 for the same reference, I wouldn't expect to see them here since they netted out.
As to using the Excel addin, it does essentially the same thing as the crystal report. It's not as easy as just selecting a few different accounts, a date range, and then seeing the transactions.
That's another point, we would love to see trial balance details for just a few select accounts instead off all of them or accounts with contiguous numbers.
Release 372
One problem is that when we produce the report with details, it gives us all the ins and outs. If we had offsetting transactions where we credited $150 and debited $150 for the same reference, I wouldn't expect to see them here since they netted out.
As to using the Excel addin, it does essentially the same thing as the crystal report. It's not as easy as just selecting a few different accounts, a date range, and then seeing the transactions.
That's another point, we would love to see trial balance details for just a few select accounts instead off all of them or accounts with contiguous numbers.
crystalreporting
Instructor
There are a number of ways to get the information you need. For individual accounts you could simply use the card view and export the results (then collate them all in MSExcel). You could also use the Ctrl-Q functionality to paste the SQL statement into the Excel Add-in select report.
The GL Trial Balance report was added to ES in 372, so I had requests to produce prior to then. You can find a copy of one on my website.
Most GL accounts can be designated as 'matching' accounts. When you configure a GL account this way, you can link transactions to each other in the card view. You can then choose to view linked versus unlinked transactions - this is useful for hiding transactions that net to zero from the card view.
To find this option, go into G/L > General Ledger > Chart of Accounts and highlight the account you want to change. Click on Open and then make sure you are looking at Advanced screen. Check the box for Matching and save.
Peter Shirley
Macola Consultant, PA and surrounding states.
The GL Trial Balance report was added to ES in 372, so I had requests to produce prior to then. You can find a copy of one on my website.
Most GL accounts can be designated as 'matching' accounts. When you configure a GL account this way, you can link transactions to each other in the card view. You can then choose to view linked versus unlinked transactions - this is useful for hiding transactions that net to zero from the card view.
To find this option, go into G/L > General Ledger > Chart of Accounts and highlight the account you want to change. Click on Open and then make sure you are looking at Advanced screen. Check the box for Matching and save.
Peter Shirley
Macola Consultant, PA and surrounding states.
- Thread starter
- #5
I have “Matching” checked in GL account 11210 so when I run a Trial Balance report I wouldn’t expect to see the ins and outs if they net but I do. For example, on 4/7/2009 we had offsetting transactions for $7,008.70 and -$7,008.70 and both are tagged SO #20302/Auth #265888 in the reference. But, they both show up on the Trial Balance report. Should the "Matching" checkbox take care of my not seeing the ins and outs on the Trial Balance report?
- Status
Similar threads
- Locked
- Question