Manual Fund Upload- The New Way

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 extraction, analysis, and display of financial data. To streamline your workflow when uploading the Trial Balance while creating a Manual Fund from SMSF Auditomation and uploading the Trial Balance, follow these steps:

Create Job

Step 1: Navigate to the Audit > Manage Funds. Click on the Create Audit Job icon for the selected fund (for jobs created internally)



Step 1: Click on Audit > Manage Jobs > Submitted By Accountants. Click on the Create Audit Job icon for the selected fund (for jobs received externally)



Step 2: Select Job Type, Financial Year, Accounting Software, and Assigned Staff.
Step 3: Click Create and Next.





Step 4: On the next screen, you have the option to select supporting documents for the fund from your device by clicking on Browse Files, or you can skip this step.



Step 5: Your job will be successfully created, and you can view the relevant job details on your screen.
Step 6: Click on Audit Job Queue or you can also click on Audit > Manage Jobs, > Audit Job Queue page.



Process Job and Upload Trial Balance

Step 7: In the Audit Job Queue, click on the Process Audit Job icon to initiate the job processing.



Step 8: On the appearing screen, you can add Templates and upload the Trial Balance.
Step 9: After uploading, click on Process Trial Balance.



Note:-
  1. The trial balance process will start and be visible on your screen. During this process, data will be read and extracted from the uploaded document in the appropriate manner. 
  2. You can directly upload Trial Balance documents in PDF, XLS, XLSX and CSV formats



Map Buckets

Step 10: The trial balance will open in a new tab. Map the unmapped transactions and line items to the relevant buckets.



Step 11: You can select the accounts and map them in bulk. Select the accounts by clicking on the checkbox next to the Account Number. Now click on the Map to icon and then click on the drop-down and select the bucket where you want to map the account.



Add Account

Step 12: You can also click on the Add Account button from the top right. Add mandatory details like Account Number, Account Name, QTY, Current Year Debit, Current Year Credit, Previous year, Debit/Credit and Map Buckets to add a completely new account from this page itself.



Step 13: As you scroll down, you'll notice that some line items have been automatically mapped to the relevant bucket.



Note: The system automatically stores mapped data at the company level which automatically maps the line items or transactions to the same bucket as in the previous year.

Save and Review

Step 14: You can click on Save and Review, to save the incomplete mapping. 



Step 15: Clicking on Save & Preview will redirect you to a new tab where you can view all the Mapped and Unmapped transactions together and you can refer to and match the financial data as well.



Step 16: Once done with mapping click Proceed. The trial balance will be moved to the relevant buckets on the Process page from the Fund Dashboard.



Note: If there are any remaining line items or transactions left to be mapped, the Proceed button will remain disabled.
You can continue your work from the Process page on the Fund Dashboard

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

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

    • Audit Job Queue

      Introduction When a job is created, initially it will be listed under Audit Job Queue. Till this stage the license is not consumed, once the job is processed from here, the license will be utilized. To know if the license has been utilized or not, ...

    • How to Delete A Fund

      Introduction You can not delete a client for which a job already exists in any of the job lists (Audit Job Queue, My Audit Job, Completed Jobs, Deleted Jobs). To delete a client, follow the given process. Step 1:- Click on Audit > Manage Funds and ...

    • Process

      Introduction The Process is categorized into Assets, Liabilities, Member Entitlements, Income, Expenses, and Review Checklist. All these headings are subdivided into Buckets and they are further divided into Line Items. All of the buckets have their ...