Determining what is reporting to the Financial Statement

Determining what is reporting to the Financial Statement VUE_Training

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?