Overview of Brightpearl accounting

General ledger

The General Ledger is the central collection point for all your financial transactions. All events that occur throughout the whole of Brightpearl which have a financial impact will be reflected in your General Ledger.

The first step to capturing your transactions is to ensure your chart of accounts is set up. This determines how your accounting information is collected, categorized and reported. If you're migrating from another system you can import your chart of accounts and opening balances.

Next you'll need to define your accounting periods, these control the dates financial transactions can be processed for.

You will need to learn how financial transactions are created in the General Ledger from sales, purchases and inventory, and how to identify what type of journal you can expect to see for different events occurring from each.

Accounts receivable

A customer record is required for every sales order and denotes the billing name and address, accounts department email, specific tax details, currency and prices. Credit terms and limits can be assigned to prevent debt getting out of control. A customer account and balance is easily accessible with a full financial history being retained.

Invoices, statements and letters can be sent to notify customers of their obligation to pay, with aging reports assisting with the collection of cash.

Payments received from customers and other sources can be receipted against customers, orders and invoices.

Sales credits are used to refund customers or give them credit against other purchases they make.

A quick invoice or quick credit can be used to increase and decrease a customer account balance respectively without producing any invoice/credit document or detail.

Accounts payable

A supplier record is required for every purchase order and denotes your billing name and address, specific tax details, currency and prices. Credit terms and limits can be assigned to prevent your debt getting out of control. A supplier account and balance is easily accessible with a full financial history being retained.

Invoices are posted directly against a purchase order to record your obligation to pay, with aging reports assisting with managing your debts.

Payments made to suppliers can be entered against supplier accounts, orders and invoices. A remittance advice can be sent to the supplier to inform them of the payment and what it relates to.

Purchase credits are used to record refunds from suppliers or a credit against other purchases you make.

A bill or supplier credit can be used to increase and decrease a supplier account balance respectively without producing any purchase order detail.

Banking

Each bank account you have, and even credit cards, should be created in Brightpearl so that when you're processing transactions you can keep a realistic view of what's actually been paid in and out of each account.

Adding a bank account to Brightpearl will not connect to your bank. Entering transactions such as payments, deposits and account transfers in Brightpearl is purely for reference, tracking and accounting purposes. The actual withdrawal and deposit of cash must be made with your bank.

Use the bank reconciliation to ensure that what happens in your real bank account is also what is accounted for in Brightpearl. If you keep on top of that, it is one less thing to worry about when it comes to your end of year.

Bank matching can be used to import an electronic bank statement. This process allows you to automatically create accounting for statement lines not yet processed in Brightpearl, at the same time as matching statement lines to existing entries in Brightpearl.

Tax

Tax is relevant throughout Brightpearl; across sales, purchases and other transactions directly affecting the General Ledger. How and what rate of tax is applied depends on your tax setup and controls.

Brightpearl is set to either US Sales Tax, or UK VAT which can be the standard or cash scheme.

Tax will be automatically applied to sales and purchases based on rules relating to countries, zones, customers and products, but can also be manually overridden.

Tax reporting in Brightpearl assists with completing tax or VAT returns.

Multi-currency

Before the release of multi-currency

Brightpearl only ever uses a single base currency for accounting purposes, but you can still use other currencies for pricing and invoicing.

Currencies can be assigned to customers, suppliers and price lists which then allows foreign currency orders and invoicing.

All payments, bank accounts and financial reports are managed in base currency.

After the release of multi-currency

Brightpearl is a multi-currency system - this means you can operate in and process transactions in multiple currencies, including product pricing, orders, invoices and payments. Brightpearl accounting manages foreign currency bank accounts, accounts receivable and accounts payable. All inventory and financial reporting is managed in base currency.

Read more detail about multi-currency Brightpearl

Importing & exporting accounting

The accounting import routines allow you to migrate data from another system to Brightpearl and the exports allow you to manipulate and store data.

Before importing your accounting data into Brightpearl you'll need to export it from your old system. We provide a selection of help guides on how to export data from Sage, MYOB, TAS Basic and TAS V3.

Once you have your data files they'll need to be formatted to match Brightpearl's requirements. When your files are ready you are able to import your chart of accounts, opening account balances, customers, suppliers, accounts receivable and accounts payable.

All reports in Brightpearl can be exported into Excel. Additional data can sometimes be exported from the database that isn't available on the screen. Exporting allows you to manipulate the data as you wish by moving columns, combining reports, doing calculations and producing graphs.

Integrations

Brightpearl can be connected to a number of payment providers which will allow you to processes card payments online. These payments can be transferred to Brightpearl to mark the relevant invoices as paid and update your accounting. It is recommended that you create a separate bank account for each payment provider you use. This will accurately reflect the real world, since money held with one payment provider, e.g. PayPal, will not be visible in you main bank account until you transfer it over. This will also allow you to easily see how much money has been processed through each account and allow you to easily reconcile them should you wish to.

Reporting

Brightpearl provides several key financial reports, such as the balance sheet and profit & loss. There are many more reports available to monitoring accounts receivable, payable, bank accounts, tax and payments. Additional filters are also provided to enable you to get the data you need. All your reports can be exported to Excel for further manipulation, comparison and analysis.

Have more questions? Submit a request

0 Comments

Article is closed for comments.