First of all, please send us the concordance between your accounts and our main accounts. All you have to do is replace the #### with the number of your account charter.

Note: Do not send your account charter, as it may contain 3 bank accounts. If the first bank account is your US bank account and I choose it, the transactions will be imported into the wrong account. Same thing for GST collected on sales, QST collected on sales, etc. Ask your accountant for advice if necessary.

Note: If an account does not exist, you will need to create it in your account charter.
By default, means that the computer will choose this account instead of another. On the other hand, this does not mean that the others will not be available, because all your other accounts will also be imported.
Replace #### with your account numbers from your current account charter.

Default bank, usually 1020
#### Current profit, usually 3150 (Net profit)
#### Main income default, usually 4200
#### Main purchase default, usually 5200
#### Account receivable Customers / Receivable, Usually 1200
#### Account Payable Suppliers / Payable, Usually 2100
#### Customer discount Early Pmt and sales discount, Usually 4240
#### Supplier discount Early Pmt and discount on purchases, Usually 5240
#### GST collected on sales (Payable), Usually 2310
#### QST collected on sales (Payable), Usually 2340
#### GST paid on purchases (Receivable), Usually 2315
#### QST paid on purchases (Receivable), Usually 2345
#### Adjustments account
#### Account for commissions (Optional)
#### Accounts for customer acquisition costs (Optional)
#### Accounts for variable costs (Optional)

We will use this information to match your accounts with those of GEM-CAR when importing into our internal tool.

Once the list of main accounts is completed, I can contact you to export your files Acomba to Excel.

1. Open your Acomba
2. Log in with an account with full rights
3. Generate reports

AcombaX: For each report generated, export in .xls format

Other (Acomba<= 9)
For each report generated:

Wait for the report to finish generating, you will know when the red Stop symbol turns gray.

Click the button at the top of this window "Paper/Number Mode"

Right-click in the report and select “Select All”

Right-click again in the report and click “Copy to spreadsheet”. This will open Excel, create a new empty spreadsheet and paste the contents starting from cell A1. (Be careful not to find yourself "in" cell A1, in other words, after pasting, you should have a value in cell B1 too). Then save the file in .xls format.

Here are the reports to be released:

Clients
"Clients" tab -> "Client Reports" button -> " Customers List " tab (Options: "Include: All", Type: "Complete")
Suggested file name: Clients.xls

Suppliers
"Suppliers" tab -> "Suppliers reports" button -> " Suppliers list " tab (Options: "All", Type: "Complete")
Suggested file name: Suppliers.xls

Charter of accounts
"Accounting" tab -> " List of accounts " button (Options: "Summary", "Accounts, All")
Suggested file name: Charter of accounts.xls

Transactions
"Accounting" tab -> " Transaction report " button (Type: "Detailed", "Include Check, Deposit, Entries", Periods: "All")
*If the report is too large, you can output it in several periods and make a file by periods. To find out how many periods you have, start by exporting the current period, if the report begins with "Detailed list of checks for period 7, finish exporting the current period and then export periods 1 to 6.
File name suggested: Transactions.xls

Trial balance
"Accounting" tab -> "Financial reports" button -> " Trial balance " tab (Include: "Inactive accounts", Periods: "All")
Suggested file name: Trial balance.xls

Age of accounts receivable
"Customers" tab -> "Customer reports" button -> " Age of accounts " tab (Options: "All", Date: "Today")
Suggested file name: Age of accounts receivable.xls

Age of accounts payable
"Suppliers" tab -> "Suppliers reports" button -> " Age of accounts " tab (Options: "All", Date: "Today")
Suggested file name: Age of accounts payable.xls

Status of accounts receivable
"Customers" tab -> "Client reports" button -> " Accounts status " tab (Options: "All", Date: "Today")
Suggested file name: Status of accounts receivable.xls

Products and services
"Inventory" tab, "Inventory reports" button -> " Inventory list " tab (Options: Include All products, All and check all boxes"
Suggested file name: Stocks.xls

Make sure your files have column headers. Otherwise, download the templates in the Attached Files section at the bottom of this article or ask This email address is being protected from spambots. You need JavaScript enabled to view it. .

Send us the xls files you generated.

Internal Reference

1. Clients.xlsx
2. Suppliers.xlsx
3. Account charter.xlsx
4. Transactions.xlsx
5. Trial balance.xlsx
6. Age of accounts receivable.xlsx
7. Age of accounts payable.xlsx
8. Statement of accounts receivable.xlsx
9. Products and services.xlsx