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 and a blank General Ledger 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.

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

​

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. 

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. 

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.

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.

For further information or assistance, please contact support@cloudoffis.com.au

• Related Articles

• Manual Fund Upload- The New Way

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

• How To Create A Job

  Introduction Creating a job is the very first step to get your work going. You can create a job and assign it to your staff by following the steps given below . Creating Audit Job for Imported Funds Step 1:- Login to the platform using your ...

• Zero Taxation Balance Update

  Introduction This article addresses a scenario where zero taxation balances might still make necessary the presence of related checklists. This logic ensures that the Taxation Balance Checklist will be provided to all funds, regardless of whether ...

• Financial Reports

  All Financial Reports of the funds will be available here. However, they defer depending upon the software from which you have imported them. Following are the financial reports of the given accounting software: BGL 360 General Ledger Investment ...