top of page

Clients Table

Updated: 4 days ago

The Clients table is the second table in the navigation menu of the Accounting CRM.



Once a client is added, their upcoming tasks will schedule immediately. This table is also where all the services for a specific client are switched on. Please make sure that each client has been assigned a status. Only Active and Dormant clients will generate tasks.


* If a task table is empty after the service has been switched on, it might mean that the due date is too far in the future or relies on a SARS due date that hasn't been released yet. These tasks will schedule at a later stage or once SARS releases the necessary dates, allowing enough time for staff to complete the task.

This post contains three categories:

  1. Adding or editing Clients

  2. Sections and columns explained

  3. Navigating to tasks through the client table.

  4. Client Summary and Work In Progress Report

1. Adding or editing clients


Click on 'ADD RECORD' in the top right corner to add a new client.

To do a bulk upload, please follow the steps in this link.



Once you select an existing client or add a new client, an edit screen will open on the right. Expand the view by clicking on the expansion bar shown below. You can collapse the view by clicking on the same bar.


When adding a new client, enter all the relevant details, then click Save&New to add another client or Save&Edit to view tasks for this specific client.


2. Sections & Columns Explained


There are several Sections when adding a client, the sections are clearly labelled and each contains various fields which you can fill in. When hovering over a field, a tooltip will appear, explaining the field.


Below is a list of a few columns to note broken down per section:


Client Details

  • Status: This indicates if you are currently providing services to this client

Active: Clients will generate tasks.

Inactive: Clients will no longer generate tasks but will keep historical data.

Pending: Used when onboarding or negotiating rates. These clients will not generate tasks.

Dormant: Clients will generate CIPC Annual Returns tasks only.

  • Rate Group: Assign a rate group to each client based on their billing structure. To set up your rate groups, please follow the steps in this post.

  • Client Name: This is the name that will display on all tasks and needs to be unique for each client.

  • Registration Nr: Company registration numbers or ID numbers for individuals

  • Registration Date: Company registration dates or the date of birth for an individual. (This column is required for CIPC and Tax tasks to schedule correctly.)

  • Year End: This column is required for CIPC and Tax tasks to schedule correctly.

  • Trading Name: Enter a trading name only if it differs from the client name.

  • Group: This column is used to distinguish clients that fall under the same group of companies. It is a text column, so it can be used for any internal grouping structure used by your firm.

Roles


This section allows users to assign staff to a client for specific tasks. This only relates to the specific client. To set the User Access restrictions for users after assigning them here, please read this post.

  • Partner/Manager: The persons that needs to do the final sign-off on tasks.

  • Accountant: Any staff member assigned as an accountant will be responsible for all tasks for the client unless another role is selected. Other selected roles will replace the accountant for that specific client and task department.

  • Accounting Role: This staff member will be assigned as the accountant to this client for all tasks under the Accounting group (grouping can be viewed in the left navigation in the app).

Tasks include:

Accounting

VAT Returns


  • CIPC Role: This staff member will be assigned as the accountant to this client for all tasks under the CIPC group (grouping can be viewed in the left navigation in the app)

Tasks include:

CIPC Annual Returns

CIPC Tasks

  • Financials & Tax Role: This staff member will be assigned as the accountant to this client for all tasks under the Financials&Tax group (grouping can be viewed in the left navigation in the app)

Tasks include:

Financials & Income Tax

  • HR Role: This staff member will be assigned as the accountant to this client for all tasks under the Payroll group (grouping can be viewed in the left navigation in the app)

Tasks include:

Compensation Fund ROE

EMP201

EMP501 Bi-Annual Recon

Payroll

UIF uFiling

  • Tax Role: This staff member will be assigned as the accountant to this client for all tasks under the Tax group (grouping can be viewed in the left navigation in the app)

Tasks include:

Income Tax Individuals

Provisional Tax Returns

SARS Tasks

Turnover Tax


Services


This section contains checkboxes for all the services provided to the client. Once checked, and saved, the tasks will start to populate for that client.


Some columns to take note of:

  • Bi-Weekly Pay Date: The Due Date will schedule for the closest Friday to your selected date

  • UIF: This is for clients who require uFiling, such as domestic workers.

  • Financials: This is a text column, so any custom note can be added

  • Document Folder: This is a way to indicate if documents for this client are stored on an external device/app.

  • Rating: Any internal rating system used by your firm

Directors Details


The Directors Details section in the client table is a summary view. More details and more directors can be added in the Directors table, explained at this link.


3. Navigating to tasks through the client table.


When you select an existing client or click Save&Edit on a new client, and expand the edit screen, you will see department tabs at the top of the table containing all the tasks.


Once you click on a tab, the tasks will show. Clicking on a task will take you to the task table filtered on the specific client. Users can work on a task from here by clicking on the task.



4. Client Summary and Work In Progress Report


To find out more about the Client Summary and Work In Progress Report, click on this link.

79 views

Recent Posts

See All
Post: Blog2 Post
bottom of page