Cloudoffis Format For Uploading Trial Balance Manually
Introduction:-
The Trial Balance Template is designed to help you standardize and organize 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.
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.
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;
- A 3-digit number creates a section, you will be asked to
manually map the section (e.g. 001)
- 6-digit numbers separated by a forward slash create
sub-sections (e.g. 001/001)
- Section number cannot be duplicated
- 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.
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. Contact our Support team if you need any assistance.
Related Articles
How to Upload Client Manually
Introduction If you perform audits using software not partnered with Cloudoffis, you can still bring your audits onto our platform through a manual process. This involves creating audit jobs using our Trial Balance template. Here are the steps to ...What's New 6.2.4
Prepared by, Reviewed by, and Audited by Sign offs We've introduced a comprehensive feature on the Job, allowing users to effortlessly track individuals responsible for preparing, reviewing, and auditing audit files. Keep tracks on completion dates ...Remapping Items
Introduction In certain cases, SMSF Auditomation might not recognize lead schedule items due to Chart of Accounts (COA) or placement issues. To address this, you can manually remap these items. Note:- This remapping feature is designed for manually ...Creating and Processing a Manual Job
Introduction With our latest update, users can effortlessly upload Trial Balance in PDF, CSV, XLSX, and XLS formats. The system automatically stores mapped data at the company level, reducing job processing time. Explore the power of AI-driven ...Release 3.3
Release 3.3 A new month a new release, 2019 has already seen some tremendous enhancements and here are some more! The below enhancements are a direct result of client feedback (with a little help from the ATO), please keep them coming. Multi Factor ...