How To Upgrade the Accounting Template From 3rd Grade to 4th Grade?

Our accounting template now supports 4th grade! For users who have installed the old template, please follow the steps below to upgrade:

Step 1: Upgrade Template

Access the Install Template to update the "Accounting" templates.

Note:

1. If you see the "Get" button instead of the "Update" button in the above window, it means you haven't installed the template before. You'll have the latest versions of sheet design and accounting reports by clicking the "Get" button.

2. If you’ve previously customized any sheets in the template, these customizations will be reverted to the default version. You can retrieve your previous sheet designs using Sheet and Field Version History. Please reconsider whether you still want to upgrade.

Step 2: Add a "Node ID" Field on the "Account Titles" Sheet

On the "Account Titles" sheet, add a "Node ID" Auto Generate field with {Ragic_ID} format:

Save the design first and run Populate Empty Values to fill in values.

Step 3: Export All "Account Titles" Entries

In the exported file, please move the "Node ID" field to the first column of your Excel. Then, input the corresponding "Fourth Grade" values. The format should be:

xxxx-account names

For example,

1111-Cash And Cash Equivalents

Tips:

1. This step is for updating existing account titles. If you need to add new accounts after the update, please refer to this guide.

2. Please make sure all "Fourth Grade" fields have values.

Step 4: Import the Excel File to the "Account Titles" Sheet

Please ensure the "Node ID" field is located in the first column of the Excel file. Otherwise, an error may occur. Besides, please check Fill in default field values and Recalculate all formulas in the Advanced Settings.

Step 5: Sync Links and Loaded Values with Updated Source Values for All Records in the "Journal Entry" Sheet

Once completed, you'll be able to generate accounting reports with 4th grade account titles.