QuickBooks Online - API

Please note, nominal mapping displayed in this video is for illustration purposes only. Please make sure the correct accounts are chosen to ensure the integration is set up correctly.

BrightPay's payroll journal feature allows users to create wage journals from the finalised payslips and upload into your QuickBooks Online accounts package using API.

Within Payroll select Journal on the menu toolbar followed by QuickBooks.

On the next screen, choose QuickBooks Online as your destination.

Set your Date Range, the journal will include records for all payslips across all pay frequencies with a pay date within the selected range.

Under Roll up select whether you would like the journal to include individual records for each employee or whether to merge the records for each unique date.

Click Continue - Sign into your QuickBooks Online account if prompted to do so.

Your nominal ledger codes will now be retrieved from QuickBooks Online.

Simply map each payroll data item to the relevant nominal account code - A nominal account code can be used for multiple items.

When ready to proceed - click 'Continue'.

Nominal ledger mapping variations - allows you to specify any circumstances for which amounts should be mapped to an alternate nominal account code.

For each payroll data item you wish to add a variation for - click Add Variation.

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.

You wish the salaries of all directors within the accounting department to be mapped to the same nominal account within your accounting software.

Your rules will be set as shown on screen.

Click Save when complete.

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

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.

Once variations have been set, these can be edited, deleted or re-ordered by clicking the spanner symbol next to it.

Also clicking the nominal account information displayed in green provides quick access to the rules that have been set for it.

When you have finished creating your variations - click 'Continue'.

Your journal will now be displayed on screen for review.

Simply click the 'Back' button to make any amendments.

When ready to upload your journal - click 'Send to QuickBooks...'

A confirmation will be displayed on screen to confirm successful upload into your QuickBooks Online account.

If you want to print, email or export a copy of your journal as a PDF -‘Press 'Print'

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.


Order using your Bright ID

Creating a new Bright ID

Using an existing Bright ID


Demos

Getting Started with BrightPay

BrightPay Payroll Demo

BrightPay Connect

Employee Smartphone App Demo


Employer

Setting up a New Employer

Additional Employer Information


Employees

Adding an Employee - Personal / Employment Details

Adding an Employee - Tax / NIC

Adding an Employee - Payment Information

Setting up a Director

Employee Calendar


Importing into BrightPay

Importing Employees via CSV file

Importing Employees via FPS file

Importing from Previous Tax Year

Importing from Sage

Importing from IRIS

Importing from HMRC Basic PAYE Tools


Processing Payroll

Payment Schedule

Running Payroll

Additions and Deductions

Pension Deductions

Attachment Orders

Processing Holiday Pay

Allocating Pay Across Departments

Finalising Payslips

Making Corrections to Payroll

Paying employees with Modulr


Payslips

Email Payslips

Export Payslips

Print Payslips


Starters and Leavers

Mid Year Starter

Processing Leavers


Statutory Payments

Shared Parental Pay (ShPP) Birth

Shared Parental Pay (ShPP) Adoption

Statutory Sick Pay

Statutory Maternity Pay

Statutory Adoption Pay

Ordinary Statutory Paternity Pay (Birth)

Ordinary Statutory Paternity Pay (Adoption)


HMRC

Ascertaining Payments Due to HMRC

Real Time Information


Payroll Journals

AccountsIQ - API

ClearBooks - API

Exact Accounting - CSV File

FreeAgent - API

FreshBooks - API

Generic Payroll Journal Integration

KashFlow - API

Nominal Ledger Mapping - Custom Items

QuickBooks Online - API

QuickFile - API

Sage Business Cloud Accounting - API

Twinfield - API

Xero - API

Zoho Books - API


Automatic Enrolment - API Integration

Click here for more Auto Enrolment videos.

 

Aviva API Integration

NEST

The People's Pension

Smart Pension


Automatic Enrolment Features

Employee Assessment

Enrolling Employees

Postponement

Opt Outs & Refunds

AE Reporting

Ongoing Monitoring

Auto Enrolment - The Movie!


BrightPay Connect

Click here for more information about BrightPay Connect.

 

BrightPay Connect Overview

Setting up BrightPay Connect

Billing Account


CIS (Construction Industry Scheme)

CIS - Entering Contractor and Subcontractor Details

CIS - Processing Subcontractor Details

CIS Submissions to HMRC


General

5 Steps to Completing the Tax Year

Downloading and Installing

Reporting and Analysis


Webinars On Demand

Must-have features for a busy payroll processor - 11am

The power of payroll and pension integration