BrightAccountsProduction provides a simple and efficient import routine, which allows you to upload datasets from Relate Accounts Production and other third party software providers to BrightAccountsProduction. You can also have the same business linked on both BrightAccountsProduction and BrightBooks, our cloud-hosted accounting software so that when you import datasets from Relate Accounts Production, business in both software are updated.

Bright AP allows for one import per client, we advise you choose the most up to date dataset to import. The routine will import the current year transactions plus up to 5 years worth of comparatives, it will also import client specific information such as addresses, data entered to the compliance database etc.

Benefits 

No manual setting up of clients and accounts datasets. Just import and get started.

Trial Balance Import for BTC AP Companies, Sole Traders and LLPs

Overview

BrightAccountsProduction now supports Trial Balance (TB) import from BrightTax Accounts Production (BTC AP) for Companies, Sole Traders, and LLPs.

This feature enables users migrating from BTC AP to seamlessly transfer accounting data into BrightAccountsProduction using a default mapping template, eliminating the need for manual nominal code mapping.

Background

This functionality supports the migration path for FRS 105 customers moving from BTC AP to BAP. A default TB import mapping template allows quick, accurate, and consistent data migration for multiple entity types.

Nominal code mappings are defined using the provided Excel file:

• Tab 1: Company
• Tab 2: Sole Trader
• Tab 3: LLP (Partnership)

These tabs map BTC AP nominal codes to BAP nominal codes for each entity type.

Key Features

• Default mapping templates for Company, Sole Trader, and LLP entity types.
• Preserves account structure and groupings during import.
• Automatically maps BTC AP nominal codes to BAP equivalents.
• Flags unmapped codes for manual review.
• Supports debit/credit balances without data loss.
• User-friendly template selection based on entity type.

How to Use

Step 1: Select Source System

1. Open your client dataset in BrightAccountsProduction.
2. Navigate to Trial Balance Import.
3. Select BTC AP as the source system.

Step 2: Choose Mapping Template

1. Select the appropriate default mapping template based on your entity type:
   • Company
   • Sole Trader
   • Partnership/LLP
2. Templates are clearly labelled for easy identification.

Step 3: Import Trial Balance

1. Run the TB import process using the selected mapping template.
2. The system automatically maps BTC AP nominal codes to the corresponding BAP codes.
3. All balances, account structures, and groupings are preserved.

Step 4: Review Unmapped Codes

• If the import encounters nominal codes not included in the default mapping, the system will:
  • Flag these codes for manual review.
  • Provide guidance on how to resolve unmapped codes.

Data Integrity

• All imported balances are accurately transferred to BAP nominal codes.
• Debit/credit balances are preserved.
• No data is lost during the mapping process.
• Duplicate user-defined template names are managed to prevent conflicts.