Completing the Trial Balance in the Portal

As part of the submission process, the accountant must complete the school’s Trial Balance in the Accounts Portal. There are two ways to do this:

Option 1 – Manual Entry in the Portal

• Open the Trial Balance page in the portal.
• Type in the figures directly beside the relevant nominal codes.

Option 2 – Upload an Excel Trial Balance to the Portal

You can upload the TB in Excel format using one of the two import templates:

     A. Excel Import Template – Copy & Paste of the COA codes and account balances

• Download the template.
• Copy and paste the TB from your accounting software into the “Copy & Paste” tab.
• Save and upload to the portal.
  > 12345G Portal Manual Import
  (replace the sample Roll No. with the actual schools Roll no)

     B. Excel Import Template – COA prepopulated, enter account balances

• Download the template.
• Enter the amounts beside the nominal codes in the “Manual Entry” tab.
• Save and upload to the portal.
  > 12345G Portal COA Import
  (replace the sample Roll No. with the actual schools Roll no)