Finance > AR / AP Groups

AR / AP Groups (Account Receivables / Account Payables groups) is where you define the financial posting groups and GL accounts linked to each group for those transactions relating to the debtor/creditor.

While this posting group setup only applies to debtor/creditor, the other posting rules setup can be found under the Posting Configurations menu (Settings > Finance > Posting Configuration). Both setups must be completed before you can post any transaction financially.

Locate the setup menu under Settings > Finance > AR / AP Group

Please reach out to your WorkBook administrator or your Consultant if you cannot find the module/menu.

ON THIS PAGE YOU WILL FIND:


AR / AP GROUP

From the menu AR/AP groups, click on the button to add a new group in the upper grid.

  • Group code: the abbreviation or the code of this posting group. (E.g. DED EXT - use for the external debtors)

  • Description: a clear and short explanation of the group code

  • Debtor account: if this group is used on the debtor, select the relevant GL account that the debtor-related transaction will be posted to (If left blank, this code cannot be selected in the Debtor setup)

  • Creditor account: if this group is used on the creditor, select the relevant GL account that the creditor-related transaction will be posted to (If left blank, this code cannot be selected in the Creditor setup)

 

It’s possible to have a group that can be used for both Debtor and Creditor. Just simply define the GL accounts on both columns Debtor account and Creditor account.

 

Selecting the AR / AP group on Debtor

 

Selecting the AR / AP group on Creditor

 

If the WorkBook personal expense feature will be used, it is a requirement to have a posting group defined for the employee creditor with a GL account set on the creditor account column.


REPORTING GROUPS

Besides the AR / AP group, there’s an option to assign the reporting group to the debtor and/or the creditor for reporting purposes (filtering and/or grouping).

The reporting group is simply used for grouping the debtor/creditor into different groups that allows you to generate different reports accordingly.

Usually, the reporting group is set based on geography where the VAT/GST/Tax is required to handle differently (e.g. Domestic, EU, APAC, International, etc.). This enables the ability to generate the VAT/GST/Tax reports reflecting the VAT/GST/Tax handling of the different groups of Debtors/Creditors.

To create a new group, click on the icon to add a new line in the lower grid.

  • Group number: enter a code or an abbreviation for the reporting group

  • Description: a short explanation of the group

  • Scope: select an option to define if this reporting group should be used on Debtor only, Creditor only, or it can be used on both Debtor and Creditors

 

Selecting the reporting group on Debtor

 

Selecting the reporting group on Creditor


Examples of WorkBook standard reports

Here’s a couple of reports that allow you to filter and/or group using the reporting groups.

 

 


Related articles

 

© Tangram 2022. All rights reserved.