How to Upload Client Manually

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 follow:

Creating Client- Manually

Step 1:- Login to the platform using your credentials.
Step 2:- Click on Audit from the left-hand side quick menu.

Step 3:- From there, click on Manage Clients.

Step 4:- Now click on Import Clients from the top right corner of the page.


audit-manage-clients-import-new-client

Step 5:- You will now see a Pop-up menu, select Upload Clients Manually from there.


manual-upload


Step 6:- Once you select that, a side questionnaire will appear with all the details that you need to input. 

Step 7:- Enter all the information in the appropriate fields and then click on Save from the left bottom corner of the menu. 


save

Step 8:- You will receive a confirmation message and your client will be added and available for the other processes on the Manage Client page. 


client-created-successfully

Notes
Note:- If there’s any information that is missing or inappropriate, you will receive an informative text stating the error.

Populating Trial Balance Template:

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.
NotesNote: 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.
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. Contact our Support team if you need any assistance.

    • Related Articles

    • Re-creating Supermate Client

      Introduction With the API integration between Cloudoffis and SuperMate, manual client data entry is no longer valid for creating audit jobs. An API Authority Token is required to import audit data, which is obtained by integrating your SuperMate ...

    • 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 ...

    • Re-assigning Client Contact - SMSF Sorted Basic

      Introduction You can easily re-assign the client contact yourself by following these simple steps: How to Re-assign Client Contact Step 1: Click on Clients > Manage Jobs. Step 2: Now click on Submitted to Auditor(s) tab. Step 3: Click on the 3-dot ...

    • 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 ...

    • Importing Clients

      Introduction Here's how you can simply import funds from accounting software like BGL 360 & Supermate. How to Import Funds Step 1: Login to you SMSF Sorted portal and click on Clients > Manage Clients > Import Clients. BGL 360 Step 2: Click on Import ...