GEM-CAR FAQ

0 Filters

Import/ Export of Datas

Exporting Data to Excel

You may need to have some very precise accounting or management data to satisfy some very specific needs such as reports, graphs, etc. There are many places in GEM-CAR where you can export data, which will be contained in a…
325 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

How to Import a Chart of Accounts

The import and creation of your chart of accounts must be done as soon as you start using the accounting solution. Your GEM-CAR account must not have any transactions when importing a chart of accounts. If you have made transactions…
271 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

Importing Data from SAGE to GEM-CAR

It is possible to import up to 7 years of history from SAGE. Option 1 - Send us your .cab file; Option 2 - Send us your xls files. Check the integrity before sending (procedure at the bottom of this…
254 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

Exporting Clients from DTMax/Taxprep

Select your customers (put in yellow). In the menu, select Folder > Print > Customer list. Tagged customers and Export to file - comma delimited. Select the data to be exported. Determine the location of the file and name it…
252 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

How to Import Your Data from Acomba

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…
229 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

How to Import Your Data from Another Accounting Software

We have tools to suck data from Sage 50 and Acomba. If you use one of its two software programs, refer to the following articles: How to Import Your Data from Sage to GEM-CAR? How to Import Your Data from…
208 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

Importing Payables and Receivables

Option 1: With the transfer tool Transfer with the tool. If the balances do not balance, you must delete the transaction(s) with the tool (coming November 23) and move on to option #2. Option 2: Using the Excel file Transfer…
204 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

Export Inventory to a CSV File

To export your Inventory to a CSV list file, follow the instructions below. From the left main menu, click on Inventory > Products & Services. Filter products by type or category. As an example, you could choose to export tire…
199 views Posted  1 year  ago by  Olivier Brunel
Import/ Export of Datas

Exporting Data - Client, Supplier, Human Resources, Vehicles

You may need to have some very precise accounting or management data to satisfy some very specific needs such as reports, graphs, etc. There are many places in GEM-CAR where you can export data, which will be contained in a…
161 views Posted  9 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Data Import - Cleanup Tool

When you need to import your data into V15, in order to prepare it for GO-LIVE, information can sometimes be incorrect or duplicated, for example. Correcting these problems is easy: GEM-CAR has a specific tool for such cases. It's called…
136 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Exporting Quantities in Inventory

You may need to have some very precise accounting or management data to satisfy some very specific needs such as reports, graphs, etc. There are many places in GEM-CAR where you can export data, which will be contained in a…
123 views Posted  7 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Put the “Show on Invoice” and “Show on Quote” Boxes Checked on all Products

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the Put the “Show on…
117 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Reassign Category Configurations to Estimate Products (Accounting Accounts)

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the Reassign Category Configurations to…
115 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Make Products Without Inventory Quantity Inactive

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. If you select the Make Products…
115 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Delete Products that are Inactive and not in Inventory and Packages

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the Delete Products that are…
110 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Delete Unused Locations

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the Delete Unused Locations option…
109 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup tool - Remove Duplicated Vehicles

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the Remove Duplicated Vehicles option…
107 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Recalculate Inventory Quantities (e.g. Merge Duplicate Lines)

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the Recalculate Inventory Quantities (e.g.…
107 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Make Categories Without Products Inactive

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the Make Categories Without Products…
106 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas

Cleanup Tool - Renumber Clients in Numerical Order (Starting with 100)

When importing data, you can use the Cleanup Tool options to make work easier, optimize data and avoid errors. To access the Cleanup Tool, click on the left menu under Tools > Cleanup Tool. Selecting the option Renumber Clients in…
105 views Posted  6 months  ago by  Bianca da Silveira De Amorim
Import/ Export of Datas
Load more No more items

Contact Us

GEM-FAQ