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

Click here to know more about Uploading a Manual Fund and Trial Balance.

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 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. From this page, you can only create jobs for the funds that you have created Internally, ...

• How to Create and Submit Manual Funds to Auditor

  Introduction Follow the steps given below to create and submit manual fund from Sorted Basic connected portal: How to Create Manual Fund Follow the steps given below to create the Manual Fund. Step 1: After logging in to the portal, click on Clients ...

• Available Buckets for Mapping

  Introduction Manual mapping to specific buckets might be necessary due to variations in how financial data is allocated within partnering software like Class, BGL, etc. Depending on the specific allocation in your software, you might be prompted to ...

• Creating a Wind Up Job

  Introduction For the wind up funds, you can create windup job using the steps mentioned below. How to Create a Wind Up Job for a Fund Step 1- Make sure that the fund has a Wind Up Date in the accounting software if its imported. a) Class - Dashboard ...

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