Sometimes I notice rather substantial changes to our assets or overall result.
Our bookkeeper is trying her best, and we know there is some work to do there.
Now that aside, is there a good method of tracking major changes?
I know I can go to the history, but it’s really time-consuming to go through transactions one by one as there is no indication on the overall money movement.
There can be so many different reasons for the big change and I need to be able to know if it’s an issue from our side, so I can get a better understanding.
I could of course save a version of the manager.io file, but it’s not automatic. I would like to be able to roll back to figure out what time the change occurred.
This is not a matter of “rolling back.” It is a matter of looking at what transactions contribute to a specific figure on the balance sheet or profit and loss statement. Viewing History can help with that, but the primary method is drilling down on the figure you are concerned about.
This statement strongly suggests you need a different bookkeeper. Trying your best is not sufficient when it comes to accounting. You must train personnel so they get it right or find other personnel.
When I click on the number, I can see that several inventory items shows as a negative cost, but I’m non the wiser as to what transaction caused this massive change.
If I look at the top item in the summary, the “Qty” is 213 and the total cost -1,944,243.15 $
If I go to “Inventory items” and look at that item" everything looks normal.
I had a similar issue when trying to use the manual inventory revaluation when it was thrust upon us and could not figure out where the error? originated. Gave up after about four hours of searching and changing things.
In the end I just went back to the ‘Obselete Feature’ of ‘Inventory Automatic Revaluation’.
Enabling that fixed it and I’m happy with that.
In the end, it appears that our B2B office staff had changed the currency of a customer and that was the cause of this particular issue.
It would be great if there was a type of warning system or similar as there is sometimes what appears to be rather minor changes that have a massive impact. A customer currency change took our assets from 600,000 $ to -8,000,000 $ and it was not the most obvious thing to find.
I have tried that method and its not that bad in fact i find it more clean. One thing missing now is to know how these suggested costs are being calculated to avoid confusion and find errors like happened in your case.