How to Import Opening Trial Balance

Overview

Welcome to the Papercare Working Papers help section. This guide is designed to assist accountants with importing opening trial balances into our software. Follow the steps below to ensure a seamless import process for your clients’ opening trial balances.

How to Import Opening Trial Balance

Step 1: Access the Import Tab

From within the client, click on the “Import” tab.

Step 2: Bring Forward Opening Balances (If previous year accounts are prepared)

If you clicked on “Bring Forward Opening Balances” when creating the new period, all accounts with debit and credit values will populate automatically.
If you did not click on “Bring Forward Opening Balances” when creating the new period, click on “Refresh Data” to bring forward the data into the current year.

Step 3: First Period of Accounts

If this is the first period of accounts, click on the “Import” tab button.

Step 4: Download Sample Format

Download the sample format in Excel to upload the data into the software.

Step 5: Prepare the Excel File

The opening trial balance import Excel format is straightforward and contains the following columns:
SOFTWARE CODES
ACCOUNTING HEADS (mandatory)
DEBIT (mandatory)
CREDIT (mandatory)
Fill in the Accounting Heads, Debit, and Credit columns. Software codes are optional but recommended if you have pre-coded your finalisation software codes to avoid manual mapping.
If software codes are uploaded along with accounting heads and debit/credit values, the software will auto-map the codes.

Step 6: Upload the Excel File

After preparing the Excel file, drag and drop or browse the file from your local drive to upload it into the software.

Step 7: Submit the Data

Click on the “Submit” button. If the data is correctly populated, the import will be completed.
If there is an issue with the uploaded Excel file, the system will not upload the data.

Step 8: Manual Mapping (if necessary)

If you are doing the accounts for the first time on Papercare Working Papers without pre-coding the accounting heads, you will need to manually map the codes.
Once the entire trial balance is mapped, click on “Submit” at the bottom right to Import the Opening Trial Balance.

If you have any further questions or need additional assistance, please contact our support team.