Import tax transactions and counterparties

Steps

1. 1

   Open Tax Intelligence and find Import

   In the left menu, under Tax, choose Tax Intelligence. The Transactions list opens. The Import button is in the row of buttons above the list, beside Export CSV.

2. 2

   Select Import

   Select Import. The Import Transactions window opens. It accepts a CSV file or an Excel file.

   • Select Import
3. 3

   Select Template to get the column names

   Select Template. An Excel file is downloaded with the column names and three sample rows. Four columns are required: transaction date, written year, month, day; transaction type, which is INCOME for a sale and EXPENSE for a purchase; amount in dirhams; and description. The optional columns include the vendor or customer, the account and the invoice number.

   • Select Template
4. 4

   Choose your file

   Select Choose File and pick your spreadsheet. The app checks the file and shows a preview. Nothing has been imported yet.

   • Upload Choose a file: october-sales-purchases.csv
5. 5

   Read the preview

   Will import counts the good rows, here 4. Duplicates counts rows that are already in the app. Errors counts rows that cannot be read, here 1. Total is the number of rows in the file.

6. 6

   Read the rows that need fixing

   Under Rows that need fixing, each problem is listed with its row number in the file. Row 6 has no transaction date, so it will be left out. You can fix the file and choose it again, or carry on and add that purchase later.

7. 7

   Select Confirm import

   Select Confirm import, 4 rows. The button changes to Importing while the rows are saved. Wait for the counts to change from Will import to Imported. A note then says the transactions are imported but not classified yet.

   • Select Confirm import (4 rows)

   

8. 8

   Select Close and check the list

   Select Close. The four transactions are in the list, each with the source Imported and the classification Unclassified.

   • Select Close
9. 9

   Open CT Configuration and select Template

   In the left menu, under Tax, choose CT Configuration. CT stands for corporate tax. The first section, Vendors and Counterparties, is the directory of your suppliers and customers. Select Template. A file counterparties_template.csv is downloaded with the columns: name, tax registration number, country, zone type, jurisdiction, company type, address, and default corporate tax and VAT treatments, with sample rows.

   • Select Template
10. 10

    Select Bulk Upload CSV and pick the file

    Select Bulk Upload CSV and pick your file of counterparties. The file is loaded as soon as you choose it. Messages at the corner of the screen report the result.

    • Upload Choose a file: counterparties.csv
11. 11

    Read the result and the row error

    Messages at the corner report the result. One names the wrong row: row 6, invalid zone type SEASIDE, with the four accepted values, DESIGNATED_ZONE, FREE_ZONE, INTERNATIONAL and MAINLAND. Another says that sanctions screening of the 5 new counterparties is running in the background, and that until it finishes they are shown as not screened, not as clear. All five companies are listed. Wadi Print House, the row with the wrong value, has no zone and is highlighted, and the tile Unzoned counts it.

12. 12

    Set the missing zone in the list

    You can correct a row here without importing again. On the line for Wadi Print House, open the Zone type list and choose Mainland, taxable 9 per cent. The change is saved at once, and the tile Unzoned goes down.

    • Choose Zone type for Wadi Print House: Mainland (taxable 9%)
13. 13

    Select Seed from transactions

    Select Seed from transactions. Names found in the imported transactions that are not yet in the directory are added. Here Baytna Qasr Hospitality LLC, a customer from the transactions file, is added without a zone, and the totals at the top go up by one.

    • Select Seed from transactions
14. 14

    Look at the Employees section

    Under In this module, select Employees. This roster is the headcount the corporate tax engine reads. The people imported in the previous lesson are already here, because it is the same employee list. It has its own Bulk Upload CSV, which needs only a name and a start date.

    • Select Employees5 (5)