Uploading Trial Balance Manually

Cloudoffis Format For Uploading Trial Balance Manually

Introduction:-  

The Trial Balance Template is designed to help you standardise and organise fund data before starting an audit in Cloudoffis. By following the defined rules for each column and required fields, you can ensure accuracy, avoid formatting issues, and streamline the audit setup process. This guide outlines the key inputs, formatting rules, and best practices to successfully populate the template for consistent and efficient audit management.

Cloudoffis Format:-

Use the Trial Balance Template attached. There are 5 columns and 2 specific cells to populate:

Fund Name (cell B3)

Enter the Fund Name exactly as in the client creation.

Audit Year (cell B5)

Use dd/mm/yyyy format and ensure to place the date after Trial Balance at.

Last Year (column B)

Previous year's balance, use positive/negative figures.

Notes
Note: Negative figures must be preceded by the "-" symbol.

Account (column D)

Enter coded random numbers between 001 & 199. These numbers have not been mapped to buckets in Cloudoffis and you will be prompted to manually assign to the appropriate bucket during audit job creation.

The rules associated with the format of the numbers are given below;
  1. A 3-digit number creates a section, you will be asked to manually map the section (e.g. 001)
  1. 6-digit numbers separated by a forward slash create sub-sections (e.g. 001/001)
  1. Section number cannot be duplicated
  1. Numbers must be within 001 & 199

Account Name (column E)

Names for sections and subsections.

Units (column F)

Please ignore; no entries are required, but avoid deleting cell H7.

Debits (Column J)

Make sure the debit balance for the line item is a positive number with two decimal places. Don't include the "$" sign, and don't format it as currency.

Notes
Note:- You can leave this column blank.

Credits (Column L)
​

Make sure the credit balance for the line item is a positive number with two decimal places. Don't include the "$" sign, and don't format it as currency.

While this method lacks some features of Cloudoffis, it's a way to keep all your audits in one place for easy access and management.


To learn more about the process, explore best practices, and make the most of our features, please visit our Knowledge Base. You can also check our FAQ section for answers to common questions, contact our Support team if you need any assistance.