Check and verify your financials data

Find this screen

Open: Period End Routines > Verify Data > Financials.

How to

Check your bank and nominal accounts

Data for bank (cash book) accounts and nominal accounts are always corrected.

Open: Period End Routines > Verify Data > Financials.

1. Choose Nominal or Cash Book from the Module drop-down list.
2. Click OK.
3. Any errors and fixes are reported on the Error Log.

Check your customer and supplier accounts

Open: Period End Routines > Verify Data > Financials.

1. Choose Sales (customer) or Purchase (supplier) from the Module drop-down list.
2. Choose All accounts.
3. Choose whether to just report errors or report and correct errors.
4. Click OK.

Error are displayed on an additional screen.

Reset the balance for single customer or supplier account

This checks the balance of the account against the transactions posted to this account. When there is a difference, the balance is adjusted.

Open: Period End Routines > Verify Data > Financials.

1. Choose Sales or Purchase from the Module drop-down list.
2. Choose Single account.
3. Select the customer or supplier account.
4. Choose whether to just validate and report errors, or report and correct errors.
5. Click OK.

---

Useful info

When to use this

Use this to check the validity of your Sage 200 data. This checks the transactions on each account and makes sure they add up to the account balances.

For example, you might use this if you notice discrepancies in a trial balance report, or a mismatch between a bank (cash book) account and its corresponding nominal account.

Your can choose to check your nominal, bank, customer or supplier accounts. To check your stock items, sales orders and purchase orders, use the Verify Data > Commercials option. See Check and verify your commercials data.

Why do I get errors in my data?

Unfortunately, there's no simple or single answer to this. Data errors are most often caused when your application closes unexpectedly (crashes) due to a network or other PC error, when you're in the middle of posting transactions.

It's good practice to check for these errors on a regular basis. The Verify data options check and correct your data when possible.

About verifying customer and supplier accounts

This checks the following:

• The balance on each account agrees with the total of the transactions posted to each account.
• The correct transaction types are posted to each account.
• All the periods are valid.
• All the VAT numbers are correct.

About verifying bank account data

This checks the following:

• The balance on each bank (cash book) account agrees with the total of the transactions posted to each bank account.
• All standing orders and direct debits are valid.

About verifying nominal account data

This checks the following:

• The balance on each nominal account agrees with the total of the transactions posted to each account.

• Previous years balance figures for all accounts balance.

If any errors are found, these are posted to the suspense account.

---

Fix it

Some of the errors can't be fixed

There may be occasions when an error can't be fixed. These will displayed in the Error Log. In these circumstances, please contact our support team for further assistance.

---

What happens when

I choose to correct anomalies?

• The balances of your accounts are updated.
• Any imbalances in your nominal transactions are posted to your suspense account.
• All errors that have been fixed are displayed on the Error Log.

---