The tab is Accounting GJE (General Journal Entry).
As an FYI, some of the info is coming from the WIP Report tab.
The end result is to equal the "Resulting Balance Sheet Account Total"
With journal entries you have adding subtracting on "both sides" (double entry accounting).
So, the first thing is for the DR and CR columns to be equal. The Income row is accurate and does not need help. It's the balancing entry of the WIP Asset and WIP liability that needs help. First if the Income is on the DR side, then the resulting Asset or Liability must be on the CR side...and the A+L must equal Income. BUT, you have to take into consideration the previous months entry.
I have put in the correct numbers for February. But the calculations I used do not work for other months. So just use them as an example of what it should look like.
Does any of this make sense?
Bookmarks