Prepare Excel Accounting Actuals Template for Manual Import

Review a breakdown of each section within the Manual Import Template and the parameters for inputting your data

Note: This option will be enabled on an account-by-account basis. If you are a direct customer, reach out to your Customer Success Manager to discuss enabling this option. If you are a partner, email support@jirav.com with the name of the account that is interested in utilizing this import method. 

There are 6 sections within the Manual Import Template (Click here to download): 

Company Setup

Company Name - This will be the name used within Jirav. Direct customers can input their company name and partners will input their clients name
Fiscal year start month (Format: day, month, year) - This cell needs to be formatted as a Date in Excel
Accounting Method - Acceptable inputs are either Cash or Accrual
Currency 
Close Month (Format: day, month, year) - This cell needs to be formatted as a Date in Excel

Chart of Accounts (COA)

Account ID (Each account ID must be unique) – Creates mapping between Account Names and Balance Sheet/Income Statement
Parent ID (optional) – Used to create groupings/sub accounts
Account Name (Each Account Name must be unique)
Account Class – Acceptable inputs are Asset, Liability, Expense, Revenue and Equity
Account Category – Each Account Category corresponds with a specific Account Class. The acceptable Category inputs are to the right of each corresponding Class


Account Function – This is optional and can be left blank. If it is not left blank, the acceptable inputs are Accounts Receivable and Accounts Payable
Account Number – This is optional and can be left blank, or can be any text or number

Departments

This sheet is not required to import but can be used if you use departments as a part of the Income Statement. Leave blank if you do not have any department data

Department ID – These must be unique
Parent ID – This is optional and can be left blank. This can be used to create department groupings/sub departments
Department Name – These must be unique. Any rows with a Department ID must have a Department Name

Income Statement

The data in this sheet can either be cumulative and data can be added each month. A new sheet can be created each month as well. 

If you decide to create a new sheet each month - You will need to go in to the sheets with your previously imported data and delete the row at the top that defines the Type and Version. This will make sure Jirav ignores this sheet and prevent duplication errors from occurring. Find more details in our Troubleshooting Excel Manual Import article.

Account ID – This needs to be one of the account ID’s listed in the COA sheet
Department – This can be left blank, or can be used to map transactions to specific departments. If Departments are not outlined in the Department sheet, leave blank.
Calendar Month (Format: Day, Month, Year) – This entire column needs to be formatted within excel as a Date column.
Amount – The entire column needs to be formatted within excel as a Currency column.

The amount field cannot be left blank. This will cause the import to stop. Put a zero-dollar amount in the cell instead.

Balance Sheet

The data in this sheet can either be cumulative and data can be added each month. A new sheet can be created each month as well. Review this note on how to properly create a different Balance Sheet for each month. 

Account ID – This needs to be one of the account ID’s listed in the COA sheet

Calendar Month (Format: Day, Month, Year) – This entire column needs to be formatted within excel as a Date column.

Balance – The entire column needs to be formatted within excel as a Currency column.

The Balance field cannot be left blank. This will cause the import to stop. Put a zero-dollar amount in the cell instead.

COA Mapping

This sheet is the source of the chart referenced in the Chart of Accounts section of this article. It outlines the acceptable inputs for the Account Class, Account Category and Account Function fields.

 

After you have entered your accounting actuals, please see our article on how to import the template to Jirav