Configurations - Map Debit and Credit Entries

Learn how to set up data configuration between Bayzat and your accounting platforms with this article.

Once a successful connection is established between Bayzat and your accounting platforms you can initiate mapping or configuring your data with Bayzat.

The steps followed are:

Step 1: Settings >Payroll > Accounting Integrations - (Your accounting platform) > Map Data.

Step 2. Fetch and convert payroll currencies to accounting platform base currency.

Note that you can only set up one base currency from your subsidiary accounts.

Step 3. Enable mapping of accounting platform cost centers with preferred cost centers to include cost center information in the line items during the synchronization, specifically for journal entries created using the methods "By employee" or "By cost center".

Selecting the desired cost centers will allow you to map cost centers on Bayzat with cost centers on your accounting platform.

Step 4. Map employee paid via.

This step allows you to define credit entries for paid expenses through Bayzat needs to be written.

Select mode of entry for paid via options:

Once you have defined and mapped cost centers you will get an option to select the mode of entry for these cost centers.

• Consolidated entry - This will write a single consolidated summed-up entry as a debit/credit record under the paid via matched GL account.

• Entry by cost centers -This will write multiple debit/credit records summed and grouped by cost centers.

• Entry by employees - This will multiple debit/credit records grouped by the employee.

  

Defining Bank Accounts and Exchange house details:

• Map the bank account configured on Bayzat to the General Ledger Asset account.

• All banks configured under pay configurations will be listed by bank name and account number.

• You will have three options in the dropdown to Map the relevant GL account i.e. Business current account, Business savings account, and Undeposited funds.

• Similarly, All exchange houses configured under employee paid via will be listed by their names. Proceed with mapping it with the relevant General ledger account from the dropdown.

• Map and define the Cash and Cheque paid via options to the General Ledger account to write credit records to.

Step 5. Match pay items with the chart of account journals.

• All pay items that are both paid and unpaid can be matched as seen below:

Step 6. Customize journal entry line items according to the cases below:

1. Journal line items as a single consolidated entry.

• Ex: A company has 50 employees with a total of AED 100,000 in Net pay. This can be written as a journal entry line as below.

	Debit	Credit
Salaries account	AED 100,000
Bank/Cash		AED 100,000

 2. Journal line items split by cost centers.

• Ex: A company has 3 cost centers.

  • Cost Center 1 has a total Net pay of AED 30,000

  • Cost Center 2 has a total Net pay of AED 20,000

  • Cost Center 3 has a total Net pay of AED 50,000

Accounts	Debit	Credit
Salaries account - Cost center 1 net pay	AED 30,000
Salaries account - Cost center 2 net pay	AED 20,000
Salaries account - Cost center 3 net pay	AED 50,000
Bank/Cash		AED 100,000

3. Journal line items split by employees.

• Ex: A company has 3 employees.

  • Emily has a total Net pay of AED 30,000

  • Joss has a total Net pay of AED 20,000

  • Blake has a total Net pay of AED 50,000

Accounts	Debit	Credit
Salaries - Emily's net pay	AED 30,000
Salaries account - Joss's net pay	AED 20,000
Salaries account - Blake's net pay	AED 50,000
Bank/Cash		AED 100,000