![Business Importer Desktop](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Business-Importer-Desktop-Reference-Number-Guide.png)
Business Importer Desktop: Reference Number Guide
In order to access Reference Numbers settings menu, click Import Settings button in the Main Window of Business Importer.
![Screenshot 2020-03-31 at 00.40.39](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Screenshot-2020-03-31-at-00.40.39-1024x605.png)
Reference Numbers can be imported by Business Importer in 3 ways:
1. Reference Numbers consequence set in Business Importer settings
![Reference Numbers consequence set in Business Importer settings](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-2-1.png)
If Generate Reference Numbers Automatically feature is ENABLED, Reference Numbers tab will be shown in Business Importer settings and import flow will be as follows:
1. Go to the Reference Numbers tab.
2. Specify Reference Number, from which import consequence starts.
3. Click Save.
![Generate Reference Numbers Automatically feature](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-3.png)
NOTICE: If you need to import Multi-line transactions, the same Reference Number must be specified for each line of one particular transaction. For Example:
![import Multi-line transaction](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-4-1.png)
Will be imported as:
![business importer desktop](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-5.png)
2. Reference Numbers imported from uploaded spreadsheet
![Reference Numbers imported from uploaded spreadsheet](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-6.png)
If Apply Reference Number from Import Spreadsheet to Transaction feature is ENABLED, Business Importer will apply Reference Numbers, specified in an uploaded spreadsheet and import flow will be as follows:
1. Specify Reference Numbers in a spreadsheet.
![Apply Reference Number from Import Spreadsheet to Transaction](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-7.png)
2. Map the Invoice Number field with corresponding header from your spreadsheet
![Map the Invoice Number field with corresponding header from your spreadsheet](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-8.png)
![business importer desktop](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-9.png)
3. Reference Numbers consequence picked up from QuickBooks Company
![Reference Numbers consequence picked up from QuickBooks Company](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-10.png)
If Generate Reference Numbers Automatically and Apply Reference Number from Import Spreadsheet to Transaction are DISABLED, Business Importer will pick up QuickBooks numeration sequence:
![Generate Reference Numbers Automatically](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-11.png)
NOTICE: If you need to import Multi-line transactions, the same Reference Number must be specified for each line of one particular transaction. For Example:
![import Multi-line transactions, the same Reference Number](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-12.png)
Will be imported as:
![map transaction reference Number column](https://cloudbusinesshq.com/wp-content/uploads/2020/03/Picture-13.png)
However in order to correctly import transactions with several products we recommend to still map transaction reference Number column specifying the same numbers for all lines of one transaction.
Remember: if you have any questions you can address them to us. We’ll be glad to help you!
Just leave us a message filling out our contact form or use the phone/email mentioned in the footer of every page.
Comments open