Import Financial Statement Reports
User can import a financial statement report from the menu Financial Reports -> Financial Statement Reports. It is recommended to download the template and fill out the columns, test the import file then when the import is error free, user can import the file and view it.
Financial Report Template
Click the button download template.
Line ID
1
Unique numeric Identifier of the line.
Yes
Line Type
D
Valid Line Type values are:
H (Heading)
D (Detail)
T (Total)
M (Math / Calculated Line)
Note: Math lines are inserted in the positions from the import, but the calculations must be entered by editing the report after import.
P (Spacer / Blank Line)
Yes
Debit or Credit
D
Valid Debit or Credit values are:
D (Debit)
C (Credit)
No
Description 1
Revenue
This is the description which will appear on the report for the line.
Yes
Description 2
Ad Revenue
The is an optional section line of the description
No
Line Style
1
Valid Line Style values are:
[Blank] (None)
1 (Single Overline)
2 (Single Underline)
3 (Single Over/Underline)
4 (Double Overline)
5 (Double Underline)
6 (Double Over/Underline)
No
Bold Line
Y
Values are:
Y (Yes)
N or [Blank] (No)
No
Print Line
N
Values are:
Y (Yes)
N or [Blank] (No)
No
Statistical Line
N
Values are:
Y (Yes)
N or [Blank] (No)
No
G/L Account Selection
01*0000*0000*1000
The G/L Account Selection allows you to enter complex, multi-valued account criteria. Multiple entries must be separated with commas and hyphens used to define ranges. The following are valid examples using a 4-level G/L structure
Select a single account: 01*0000*0000*1000
Select multiple accounts: 01*0000*0000*1000, 01*0000*0000*1001, 01*0000*0000*1002
Select a wildcard driven range: 01*0000*0000*^000
Select a range: 01*0000*0000*1000 - 01*0000*0000*2000
Select a combination: 01*0000*0000*1000 - 01*0000*0000*2000, 01*0000*0000*3000, 01*0000*^000*0000
No
Total Lines
Total Lines allows you to enter multiple lines to sum. Input must be in one of the following three formats:
Select Lines on this Report: 100, 110, 120, 130
Select Lines from other reports: 200:110, 200:120, 300:130
Mixed: 200:110, 200:120, 130
No
Comment
Note about Something
Internal comment for the line. Enter optional Alpha Numeric text here.
No
To import the report:
Enter the report ID to be able to view the report later by ID.
Enter the description of the report.
Choose the report type as profit and loss or balance sheet.
Enter the calculation sequence, if needed. (used if one report builds upon another) - can leave as zero or blank if not needed for your report.
Choose the file to import from the desktop which user filled out according to the instructions above.
Click the icon test import file to resolve any errors in the file data before executing the import. You will receive the message indicating success or errors.
Click OK to view the error details.
Correct the error in the excel sheet and then save to the desktop. The error message specifies the line where the number is.
Save the file again, and then click the x to remove the file from the system import select field. Re-select the file to ensure that the fresh copy is loaded. Click test import again and observe the error resolved.
To view the report, user navigates to the Financial Report Setup screen and selects the report ID from the list. User must check the user name boxes for users who can view this report and saves settings.
User then navigates to the financial reports menu and can pull up the report ID from the list to view.
Last updated
Was this helpful?