Quickbooks (Desktop version) - CSV upload

BrightPay's payroll journal feature allows users to create wages journals from the finalised payslips and export to IIF file format for upload into Quickbooks accounting software (Desktop version only).

If using Quickbooks Online, please click here for assistance.

1) Within Payroll, select Journal on the menu toolbar, followed by Quickbooks:

2a) On the next screen, choose Quickbooks Desktop (IIF File) as your destination


b) set your Date Range - the journal will include records for all payslips (across all pay frequencies) with a pay date within the selected range. 

c) Roll up - for successful upload into your Quickbooks software, it is important to always select the option to 'include individual records for each employee'. Unfortunately the option to 'merge employee records for each unique date' is not supported.

 
Important note:

Before your journal can be uploaded successfully, you must ensure that your employee names exist in your QuickBooks company file. This is a Quickbooks requirement and may result in error 11283 if the names have not been set up prior to upload.

Within Quickbooks, the user can go to Employees > Employee Centre > New Employee to do this.

d) Click Continue

3a) Nominal Ledger Mapping - for each of the payroll data items listed, enter the equivalent nominal account name (or code) that you have set up within Quickbooks as per example below. A nominal account name or code can be used for multiple items. A description can also be entered for each data item. 

b) When all payroll data items have been completed, click 'Continue'. 

4) Nominal Ledger Mapping - Variations - this screen allows you to specify any circumstances for which amounts should be mapped to an alternate nominal account name or code (e.g. depending on period type, directorship, departments, specific rates/additions/deductions, etc.)

a) For each payroll data item you wish to add a variation for, click Add Variation:

b) For the payroll data item selected, set the rules to apply in order for the amount to be mapped to the designated nominal account you enter on this screen.

Rules can be set according to period type, directorship, department and specific pay items.

Example

You wish the salaries of all directors within the Sales department to be mapped to the Director's Remuneration nominal account within your accounting software. Your rules may thus be set as follows:

 c) Click Save when complete.

Your rule will now be displayed on screen under the payroll data item it is associated with.

d) Further variations can be added for different pay items or for the same payroll data item by simply clicking Add Variation again and setting the rules to apply.

e) Once variations have been set, these can be edited, deleted or re-ordered by clicking the spanner symbol next to it. In addition, clicking the nominal account information displayed in green provides quick access to the rules that have been set for it.




 

f) On completion of this screen (where required), click 'Continue'.

5) Nominal Ledger Mapping - Custom Items - this screen allows you to add further adjustments to your payroll journal before posting.

This is an optional screen which can be used to record HMRC Payment adjustments such as employment allowance, recoverable statutory pay, etc. for example.

Guidance on completing this screen can be accessed here.

On completion of this screen (where required), click 'Continue'.

Your journal will now be displayed on screen for review. Simply click the 'Back' button to make any amendments. 

6a) When ready to export the journal, click the 'Export Quickbooks IIF File...' 

b) Browse to the location where you would like to save your export file to, then click 'Save'.

c) Press 'Print' to print,email or export a copy of your journal to PDF.

d) To close the journal screen, simply click the cross at the top right of this screen. If you have made any changes to the journal, you will be asked if you wish to save your changes. Click 'Yes' or 'No' as required.

Your payroll journal is now ready for upload into your Quickbooks Desktop accounting software.