Debtors File Import

A CSV file with the following columns is accepted:

Contact name - optional
Customer name - required
Balance - required
Phone number - optional

Format is ContactName,CustomerName,Balance,Phone

Do not include headers only the individual customer details.

e.g.

Joe Bloggs,JB Enterprises Ltd,5123.78,01-2986005
,Sample Company Ltd,567,
Mary,Apple Inc.,0,

Need help? Support is available at 01 8352074 or thesauruspayrollsupport@brightsg.com.

Bureau Users Only

Installation Operation User Name Changing a company name

Company details VAT Registration Legal Type Customer Statements Opening Balance Date Cut Off Date

Adding a Customer Amending Customer Details Amending a Customer Name Deleting a Customer Dormant or Unused Customers

Adding a Supplier Amending Supplier Details Amending a Supplier Name Deleting a Supplier Dormant or Unused Suppliers

Adding a Product to the Product Listing Amending a Product within the Product Listing

Opening Balances

Opening Bank and Nominal Balances Opening Customer Balances Opening Supplier Balances Debtors File Import Creditors File Import

Customising for your use

Adding Nominal Accounts Renaming sales accounts Renaming purchases accounts Bank Account Names Income Accounts Expense Accounts Directors Accounts To Show Accounts To Hide Accounts

Sales - Batch Entry Sales - Reverse Batch Entry / Credit Note Sales - Invoice/Credit Note Entry Sales - Product Invoices - New Type Sales - Retail/Cash Sales Sales - Multi VAT Invoice Entry

Sales Invoice Printing

Invoice Printing Logo Import Emailing Invoices/Credit Notes Invoices not available to print

Customer Statements

Customer Statement Options Preparing a Customer Statement Report Previewing Customer Statements

Receipts Receipts - Using Payer Option Customer Remittance Advice Reversing a Receipt Allocating Customer Receipts Reversing Customer Receipt Allocations

Sales Related Reports

Sales Day Book Aged Debtor or Customer Listing Aged Sales Invoice Listing Customer Activity Report

Bad Debts Purchases Entry

Purchases - Batch Entry Purchases - Reverse Batch Entry / Credit Note Purchases - Multi VAT Batch Entry Purchases - Multi VAT Invoice Accounting for EU Purchases

Payments Payments - Using Payee Option Reversing a Payment Allocating Supplier Payments Reversing Supplier Payment Allocations Supplier Remittance Advice

Purchases Related Reports

Purchases Day Book Aged Creditor or Supplier Listing Aged Purchase Invoice Listing Supplier Activity Report

Transfers between Bank Accounts

Reconciling Bank Accounts

Bank Reconciliation Hide Reconciled Transactions Edit Bank Transaction Amounts

Corrections and Deleting

Corrections Deleting Transactions Deleting a block of transactions

VAT VAT - Sales Invoice Basis VAT - Cash Receipts Basis Late Receipt of Invoices Amending a Tagged Transaction

Directors Transactions

Director Paying Supplier Invoices Director Incurring Expenses Payments to the Director Receipts from the Director

Subcontractors & RCT Subcontractors & Reverse Charge VAT

Principal Contractors

Principal Contractors & RCT Principal Contractors & Reverse Charge VAT

Asset Purchase Pay for Asset from Bank Account Pay for Asset by Loan Finance Lease of Asset Hire Purchase of Asset

Sales Day Book Purchases Day Book Aged Creditors/ Suppliers Listing Aged Debtors/ Customers Listing User Defined Report

Petty Cash Transactions Lease Repayments Hire Purchase Repayments Directors Salary / Remuneration Thesaurus Payroll Journal Third Party Payments / Form 46G Journal Entry

Preset Journals Journals

Exporting an Audit File Importing an Audit File

Accounts Production

Accruals Prepayments Nominal Ledger Report Trial Balance Comparatives External Trial Balance Input Management Accounts

Stock Control Archive Transactions Backing up your Company Files Restoring a Back Up CSV Import Schools Version

RCT and VAT - schools