Determining what is reporting to the Financial Statement
HS 347308872
Accounting > Schedule Reports > Schedule Summary
Select the Report Parameters including:
Report Type Export
Select Accounts Specific to the Account in question. (See Accounting > Monthly > Reporting Account Setup to review what GL accounts are reporting to a specific OEM account.)
Output to Spreadsheet
Click [Run Report] and open the resulting .xls spreadsheet.
Withing the .xls file:
1. Sort the spreadsheet for debits and credits.
a. Delete the header row.
b. Highlight the column that has the Account in question.
c. Click the Conditional Formatting tab at the top.
d. Click Highlight Cell Rules
e. Click Less Than....
f. Enter 0.00 in the pop-up.
g. Select the column again and the total matchs the GL balance in the Ledger.
2. To Get the totals for The Debit and The Credits:
a. Replace the numeric description in the top cell from the account column, with an alpha (no numbers) description.
b. Highlight the column.
c. Click the Sort and Filter Icon.
d. Click the Filter.
e. Click on the dropdown arrow.
f. Click on Filter by Color.
g. Click on the Filter by cell color that is displayed on the screen.
h. It will then give you the Sum Total fof the Credits that are shown on the FS.
i. Click the dropdown again for that column to get the Sum Total fof the Debits.
Did this answer your question?