ExpenseIn uses a powerful CSV building tool that can be easily customised so data exported from ExpenseIn can be imported directly into Sage 50.
We recommend that you have a look at the Sage 50 Import Documentation to ensure you understand how the import works.
We have created pre-defined export formats for Sage 50:
Sage 50 Reimbursable
Sage 50 Company Card
Match your references
Before you add your Sage 50 export formats to your account, you will want to match the references you have within Sage 50 package to the ones in your ExpenseIn account. This will allow the data to pull through correctly.
You can set the references up in ExpenseIn by following the steps below:
Map your categories
Navigate to Admin and click on Categories.
Click Edit next to the category and input the reference that matches your nominal code in Sage 50. Check out our Categories help article for more information on category configuration.
Map your Users
Navigate to Users in Admin.
If you’ve set your users up as suppliers in Sage 50 you will need to Edit each user and input the A/C Reference number from Sage as the Reference number in ExpenseIn. If you are importing all user expenses against one Supplier account, you can continue.
Map your Tax Rates
Navigate to Tax Rates in Admin.
The Tax Codes in Sage (e.g. 20% = T1) will need to match the Tax Rate Reference in ExpenseIn.
Map your Departments
Navigate to Departments in Admin.
If you are recording Departments in Sage 50, you should add the Department number as the Department Reference in ExpenseIn.
Map your Projects
Navigate to Projects in Admin.
If you are recording Projects in Sage 50, you should use the same tracking name for these in ExpenseIn.
Map your Cost Centres
If you have any cost centres in addition to departments or projects that you wish to capture, then these will need to be set up as a Custom Field.
Navigate to Custom Fields in Admin.
Create a Custom field using the List field type. Ensure your custom field list values match your Cost Centre codes in Sage 50.
Now that everything has been set up in the Admin area, you can add the Sage 50 CSV export format to your account.
Add Sage 50 export format
In the Admin area click Export Formats.
Click New Export Format.
3. Click the Sage 50 dropdown.
4. Depending on whether you have out of pocket expenses and/or company card expenses, you can add the appropriate format to your account.
Click Edit if you want to view the mappings between the ExpenseIn fields and Sage 50. We automatically use the names of the columns that Sage 50 requires so that the import process is as easy as possible.
If you are using cost codes then you will have needed to create a Custom Field for this earlier. Once you have done so, find the Cost Code Reference at the bottom and change Static Value by clicking the dropdown box and then choosing your Cost Code custom field from the list.
Please note: If you wish to create negative expenses on your account, check out our Advanced Settings article to toggle this setting on.
Before you get started, make sure you have set up the above references.
If your company card is set up as a Bank Account in Sage, you will need to change the Transaction Type from PI & PC to VP (Visa Payment) & VR (Visa Credit).
On the second line, you will need to add either the Supplier Reference or Account Reference that the card is set up within Sage, rather than the reference of the employee supplier.
Now that your account has been mapped to reflect your Sage 50 package and the CSV export format has been added, you can now export your expenses using this format in the Finance area. Check out our Export expenses to CSV help article.