Skip to main content

Search

Welcome to our Support

RAP Balances Not Pulling in on Bright AP After Import

Shinjinee Sarkar
  • Updated

Why are some balances missing from certain nominal codes after importing from RAP to Bright AP?

This issue occurs because the missing balances are Bookkeeping (BK) Transactions in RAP.

When selecting the Import Trial Balance option, the system imports Current Year Journals, Compliance Data, and Comparative Balances. However, Bookkeeping Transactions (BK) are not included in this import, which causes differences in nominal codes.

Key Information:

  • The only import option that includes BK Transactions is the Full Dataset Import.
  • The Full Dataset Import requires a BK Licence, which can be purchased by contacting your sales representative.
    A screenshot of a computer Description automatically generated

The system is functioning as designed, and there is no issue with the import routine.

Encountering an error message related to the deficit b/fwd concerning signage even after inputting it both ways? This issue can occur if the next submission number for the practice hasn't been entered correctly or if the number has already been used previously in RAP or another accounting software. Double-check these entries to resolve the error.

If your Trial Balance is showing discrepancies, this could be due to unresolved validation errors. Making use of the re-calculation option can help clear these validations. Ensure that any outstanding validation notices are addressed to balance your Trial Balance effectively.

ShapeSteps to Resolve the Issue:

Option 1: Manually Post Journals to Adjust for Missing BK Transactions

  1. Export the Trial Balance (TB) from RAP.
  2. Compare it with the TB in Bright AP.
  3. Manually post journals in Bright AP to adjust the differences caused by the missing BK transactions.

Option 2: Import Comparatives Only and Enter Current Year Figures

If the client is not connected to Bright Books:

  1. During Import: Select the option for Comparative Balances Only.
  2. Export your TB from RAP into Excel.
  3. After importing the dataset, go to Settings > Data > Imports > Journals. Copy and paste the figures from the exported RAP TB into Bright AP.

Option 3: Manually Post the Opening TB

If there is not much data to enter:

  1. Navigate to Nominal Ledger > Journals > New.
  2. Set the type to Opening Balance.
  3. Manually post the opening TB balances.