Welcome Guest, you are in: Login

Showbiz Help

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Quickbooks Export/Import File

RSS
Modified on 10/01/2017 12:05 PM by Suzanne Coy Categorized as Uncategorized
Under Reports>Accounts there is now a 'Quickbooks Export File' option. Selecting this generates an XLS file. This will need to be saved as a CSV file in order to import into Quickbooks.

The columns included in the report are: Date - date of the transaction Description - transaction reference Amount - total value of the transaction QBSE Category - department code conversion i.e. BI in the department code will return 'Business Income' in the import file (Please email [email protected] if you wish another department code to be added) Account - the nominal code Notes - transaction notes

Please email [email protected] if you require different columns to be included.

ScrewTurn Wiki version 3.0.3.555. Some of the icons created by FamFamFam.