Data checker

The data checker reviews your accounting database for any unusual postings or journals with missing data, for example, a journal posted to 1100 Accounts Receivable (Debtors) with no customer ID; this particular example can occur if a bank receipt is posted to record a customer payment instead of using the correct process - Payment Allocation. Check your accounting database by going to Accounting > Data Check .

The data checker checks all of the following:

CheckDescription
Unbalanced journals (Debits ≠ Credits) Debits must always equal credits in an accounting journal. Brightpearl will not allow an out of balance journal to be posted, so in the unlikely event that you do notice any warnings in this section you should contact our Support team immediately.
Entries on Creditors (Accounts Payable) 2100 with no invoice reference Automatic accounting entries made to Debtors or Creditors only occur when an order is invoiced (SI or PI journal) or a payment (SR or PP journal) is posted. Both of these stages automatically enter an invoice reference into the journal. Click on any journals listed here to try and identify how these journals occurred. Do they have the correct journal type - SI, PI, SR or PP? Anything else could indicate it wasn't processed through the correct route.
Entries on Debtors (Accounts Receivable) 110 with no invoice reference Brightpearl will warn you of any journals where there is an entry to Debtors with a zero value. Click on any journals listed here to identify why there is a zero entry. If the line should be removed you can edit the journal, this will clear it off the data check.
Entries on Creditors (Accounts Payable) with no amount Brightpearl will warn you of any journals where there is an entry to Creditors with a zero value. Click on any journals listed here to identify why there is a zero entry. If the line should be removed you can edit the journal, this will clear it off the data check.
Entries on Debtors (Accounts Receivable) with no amount Brightpearl will warn you of any journals where there is an entry to Debtors with a zero value. Click on any journals listed here to identify why there is a zero entry. If the line should be removed you can edit the journal, this will clear it off the data check.
Debtors (Accounts Receivable) or Creditors (Accounts Payable) transactions not at correct tax rate Where the Debtors and Creditors nominal codes have a tax code selected in the chart of accounts they will always expect accounting entries to have this same tax code. Where an entry uses a different code the journal will be listed here. Click on the journal ID to view the entries and ensure the Debtor/Creditor row uses the correct tax code. You should also ensure the nominal codes are using the correct tax code. To switch off this check don't select any tax code on the nominal code setup.
Transactions on tax control accounts at 0% Entries to the tax control accounts are recording the tax value of a transaction, so if the tax rate was 0% then there would be no amount posted...that makes sense. Here you will see any journals were a tax amount was posted but with at 0%. Click on the journal ID to view the entries and ensure the correct tax code was used or whether a tax amount was posted incorrectly.
Purchase invoices with no supplier ID An invoice relates to money owed to a supplier, so it makes sense that every accounting entry requires the relevant contact ID. Without a contact ID it won't update the contact account balance, it will simply be an anonymous debt that you don't know who to pay it to. Brightpearl won't allow invoices to be posted without a contact ID so ensure these journals have been created through the correct processes.
Sales Invoices with no customer ID An invoice relates to money owed by a customer, so it makes sense that every accounting entry requires the relevant contact ID. Without a contact ID it won't update the contact account balance, it will simply be an anonymous debt that you don't know who to claim it from. Brightpearl won't allow invoices to be posted without a contact ID so ensure these journals have been created through the correct processes.
Chart of Accounts check Each nominal code requires a name, if one exists with no name it will be listed here. You will need to edit the nominal code to add a name.
Transactions with no tax code set Every accounting entry needs a tax code against it, even if tax is not relevant (T9 Not rated). Ensure these journals have tax codes entered.
Journal check Journals should only ever have positive values entered; debits and credits are used to identify whether the amount is adding or subtracting from the account. Any journal which contains negative values will be listed here. Brightpearl should never allow this to happen, so in the unlikely event that you do notice any warnings in this section you should contact our Support team immediately.
 
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.