General Mapping Setup

Accounting 🡪 Settings → Mapping Setup → General

The mapping setup in the accounting module system allows users to configure how different types of transactions are automatically converted and categorised. 

This setup ensures that transactions are accurately recorded in the correct accounts, simplifying financial management and reporting.

Accessing the Mapping Setup

  • Navigate to the Accounting → Settings → Configuration → Mapping Setup → General

Select Mapping Setup to open the mapping configuration interface.

In the mapping setup, you can define how various types of transactions should be processed and categorised. This involves selecting appropriate accounts for different transaction types.

  • Invoices

    • Select the account where all the payments are coming to from invoices:

      • Example: Choose "Accounts Receivable" to record where the payments are initially received from customers.

    • Map it with the account where the payments should be deposited:

      • Example: Choose "Business Checking Account" to specify where the funds should be deposited after being recorded.

  • Discounts

    • Select the account for recording discounts given:

      • Example: Choose "Discounts Given" to track the amount of discounts offered to customers.

    • Map it with the account where the discount amounts are deducted:

      • Example: Choose "Sales Discounts" to specify where the discounts will be applied.

  • Sales

    • Select the account for recording sales transactions:

      • Example: Choose "Sales Revenue" to record income from sales.

    • Map it with the account where the sales income is deposited:

      • Example: Choose "Business Checking Account" to specify where the sales income will be deposited.

  • Expenses

    • Select the account for recording expense transactions:

      • Example: Choose "Expenses" to track all business-related expenses.

    • Map it with the account where the expense amounts are deducted:

      • Example: Choose "Operating Expenses" to specify where the expenses will be recorded.

  • Credit Note Sales

    • Select the account for recording sales credit notes:

      • Example: Choose "Sales Returns and Allowances" to track returned sales items.

    • Map it with the account where the credit note amounts are refunded:

      • Example: Choose "Customer Refunds" to specify where the credit amounts will be recorded.

  • Credit Note Refund

    • Select the account for recording refunds related to credit notes:

      • Example: Choose "Refunds Payable" to track refunds issued to customers.

    • Map it with the account where the refund amounts are deducted:

      • Example: Choose "Cash on Hand" to specify where the refund amounts will be recorded.

  • Expense Payment

    • Select the account from which expense payments are made:

      • Example: Choose "Expense Payments" to track payments for expenses.

    • Map it with the account where the expense payments are deducted:

      • Example: Choose "Cash on Hand" to specify where the expense payments will be recorded.

  • Sales Tax

    • Select the account for recording sales tax collected:

      • Example: Choose "Sales Tax Collected" to track taxes collected on sales.

    • Map it with the account where the tax amounts are deposited:

      • Example: Choose "Tax Liability" to specify where the collected sales taxes will be recorded.

  • Tax Expense

    • Select the account for recording tax expenses:

      • Example: Choose "Tax Expenses" to track tax-related expenses.

    • Map it with the account where the tax expense amounts are deducted:

      • Example: Choose "Tax Payable" to specify where the tax expenses will be recorded.

1urRT0egd55vlwS5qu8EgtdYlAJI1wjpA60wbzMO6XIz-mpWLasHXzIYNChFPquFxsYpCQT3vOxfxsE2bCbmymMi_32Pmw2vnSu2avzhrDbn-nVuQREu7IkIdOu98b3xiU8iu52Optck

Figure 1 Mapping Setup 1

 

WOTVbQMHUkgxn5hJYNKgmqwVLSH0-k5gsEGeDbjoE5_e5KiRVG5KB7kXSXecwzZZRtROoFhh7Bq5UIlv4bMfaf2aw9qvYIe_Cgh6obMoSzx8RoCMJlTdeNSlP4C1P3FRqMBqQrWhWKkQ

Figure 2 General Mapping Set Up 2

Was this article helpful?