Difference between revisions of "12 Checking Balances"
From TrueERP wiki
Simon Clive (Talk | contribs) (Created page with "Checking Balances Why do you need to check your balances? On very rare occassions your MySQL tables can get data corruption. These can be caused by any number of reasons from p...") |
Simon Clive (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | Checking Balances | + | '''Checking Balances''' |
| − | Why do you need to check your balances? | + | Why do you need to check your balances? |
| − | On very rare occassions your MySQL tables can get data corruption. These can be caused by any number of reasons | + | On very rare occassions your '''MySQL tables''' can get data corruption. These can be caused by any number of reasons from power surges to simple account set-up issues. |
| − | from power surges to simple account set-up issues. | + | |
| − | It is always a good idea, that on a | + | It is always a good idea, that on a '''Monthly''' basis to confirm that all of your data is sound and has posted correctly without corruption. |
| − | without corruption. | + | |
| − | A quick and easy way of confirming this is to simply open your | + | A quick and easy way of confirming this is to simply open your '''Balance Sheet''' and confirm that your '''Assets''' total, matches your '''Liabilities''' total. Your '''Balance Sheet''' forms the basis of every report, so if this balances, then every thing else will balance correctly. |
| − | your | + | |
| − | balance correctly. | + | |
| − | Should this | + | Should this '''Not Balance''', then move the date backwards until you get to the date on the '''Balance Sheet''', that it '''Does Balance'''. ie open the date drop down on the report, change the month, backwards by a month and re-check the assets total to your liabilities total. Once you have the faultly month, then alter the days until it again balances. |
| − | + | ||
| − | assets total to your liabilities total. Once you have the faultly month, then alter the days until it again balances. | + | |
| − | Once you know the date, open the "Transaction Journal' report, on that date and filter on the transaction types until you find | + | Once you know the date, open the '''"Transaction Journal'''' report, on that date and filter on the transaction types until you find which type of transaction is causing the in-balance. ie filter on all invoices and confirm that the totals at the bottom of the report match. |
| − | which type of transaction is causing the in-balance. ie filter on all invoices and confirm that the totals at the bottom | + | |
| − | of the report match. | + | |
| − | Once you know the types, filter on these by transaction number until you find the out of balance transaction, then simply | + | Once you know the types, filter on these by transaction number until you find the out of balance transaction, then simply '''Delete '''the '''Transaction''' and '''Re-Enter''' it. |
| − | + | ||
Latest revision as of 15:50, 8 November 2011
Checking Balances
Why do you need to check your balances?
On very rare occassions your MySQL tables can get data corruption. These can be caused by any number of reasons from power surges to simple account set-up issues.
It is always a good idea, that on a Monthly basis to confirm that all of your data is sound and has posted correctly without corruption.
A quick and easy way of confirming this is to simply open your Balance Sheet and confirm that your Assets total, matches your Liabilities total. Your Balance Sheet forms the basis of every report, so if this balances, then every thing else will balance correctly.
Should this Not Balance, then move the date backwards until you get to the date on the Balance Sheet, that it Does Balance. ie open the date drop down on the report, change the month, backwards by a month and re-check the assets total to your liabilities total. Once you have the faultly month, then alter the days until it again balances.
Once you know the date, open the "Transaction Journal' report, on that date and filter on the transaction types until you find which type of transaction is causing the in-balance. ie filter on all invoices and confirm that the totals at the bottom of the report match.
Once you know the types, filter on these by transaction number until you find the out of balance transaction, then simply Delete the Transaction and Re-Enter it.
