Brand new to community, we are trying to import csv files from our payroll service into erp mas90 and can't figure this out. We are using version 4.50.3.0.

If you have your client’s trial balance information in a CSV file, you can import their initial trial balance to save you having to enter it manually.

1. Trial Balance > Enter an initial trial balance > Import Trial BalanceorTrial Balance > Enter comparative trial balance > Import Trial Balance
2. Click .CSV template to download an example CSV file. This will help you have the information in the right columns.

3. Open the downloaded file. This should open in a spreadsheet program like Microsoft Excel.

4. You could complete this file with your client’s figures, or rearrange an existing spreadsheet you have so that the columns are in the order: Code, Name, Debits, Credits.

   When saving the CSV file after making your changes, you must save it in CSV format. Depending on what spreadsheet program you’ve used to open the CSV file, when saving you may be prompted to save it in a different format. Disregard this advice and save in CSV format.

5. Click Upload > find your client’s CSV file > Open > Clear the checkbox next to any rows you don’t want to import > make any adjustments to values > Next.

   You’ll need to review these mappings and make any adjustments you feel are needed before confirming.

6. Review the list of mappings > Make any necessary changes > Save.

   Changes you make to mappings are saved to be used by this client again in other periods.

To make changes to the mappings

Rows marked in orange with a Select a nominal account button need a nominal account selecting before you can save.

1. On a row you want to change, either click Edit or Select a nominal account. The row expands to show you the current mapping and more options.

2. Click Select another nominal account > enter the code or name > enter the value

   or Create nominal account to map > enter the nominal account details > Create.

   Repeat this step allocating the imported value to how many accounts are necessary. This can be a mixture of existing nominal accounts and newly created accounts.

3. Confirm.

   Repeat this until you’ve allocated all your account balances.

How to open CSV files

Avoiding data corruption when editing CSV files

We recommend that you open CSV files using Excel's Text Import Wizard, and do not open a CSV file directly in Excel; e.g. by double-clicking the file or using File > Open. If you open a CSV file directly in Excel, it will automatically format and convert your data, which may result in data corruption.

When you use the Text Import Wizard, you can control how the data in your file is formatted in Excel.

If you open a CSV file directly in Excel, it will automatically format and convert your data, but it may not convert it to the correct format. It will set the cells in the spreadsheet to the General data type, which formats the cells based on their content. For example, say you have an import file that contains a nominal account number '00010'. Excel will format '00010' as a number and remove the leading zeros, so your nominal account code number would be converted to '10'.

To avoid this problem, you can use the Text Import Wizard. This allows you to convert the data to the Text data type (instead of General), and means that your data will not be corrupted.

Open an CSV file using the Text Import Wizard

Note: Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.

To open a CSV import file in Excel using the Text Import Wizard:

1. In Windows Explorer, rename the CSV file with a TXT file extension. For example, rename Import.csv to Import.txt.

   This is required because Excel will not run the Text Import Wizard if the file has a CSV file extension.

2. in Excel, open the import file. Thaiphoon burner free download.

   • Select File > Open, and browse to your file. If you can't see your file, make sure the filter is set to show Text Files.

3. The Text Import Wizard is displayed.

   Such third party cookies may track your use on Drivespark sites for better rendering. However, you can change your cookie settings at any time. Our partners use cookies to ensure we show you advertising that is relevant to you. If you continue without changing your settings, we'll assume that you are happy to receive all cookies on Drivespark website. This includes cookies from third party social media websites and ad networks.

   1. Make sure the data type is set to Delimited.

      Click Next.

   2. Set the delimiter to Comma (only), and deselect Tab.

      Click Next.

   3. For each column, set the data format to Text, instead of General.

      To do this quickly, you can select all the columns at once. Scroll to the last column and use Shift + click to select all the columns. Then set their data format to Text.

      Click Finish.

4. Your file will be opened in Excel.

   Once you have finished editing the file, you can save it as a CSV file, ready to be imported in Sage 200c.

   1. Select File > Save As.
   2. Set the file type to CSV (Comma delimited) (*.csv).
   3. Choose your file name and location, then save the file.

Edit CSV import files in Excel

Tips for editing

When you're editing import files in Excel, use the following tips to make sure that the data will be saved to the CSV file in the correct format.

• Use the Text format for all cells, rather than General.
• Do not use an apostrophe to format a cell as text; e.g. do not use '001 to make Excel treat the cell as text (when the cell uses the General format). Instead, always use the Text format for the cell. The apostrophe will not be removed when you save the CSV file, so it will be included when you try to import the file in Sage 200c.
• When you save the CSV file, use the file type CSV (Comma delimited) (*.csv).

Do I need to include all the fields?

Not all fields need to be included in the import file. You only need to include the mandatory fields.

• If you do not want to include a field for a particular record, just leave that field blank.
• If you do not want to include a field for any of the records in your import file, then you can remove the field altogether (including the heading).

Related information