This is my first time using accounting software, so I’m still trying to figure out the ins and outs. I know the fundamentals of double entry accounting.
I’m using this to keep track of personal finances, so I’m attempting to input my hours worked and wages received from multiple income sources. However, I’m still getting a mismatch on the trial balance exactly equal to the amount of income, so I believe the issue is somewhere in the income workflow.
My current income workflow is as follows:
Create an entry in Billable Time for the amount of hours worked for the pay period.
Create a Sales Invoice for the gross amount of the pay stub and a single line item for “Billable time - invoiced” (the customer is assigned to the Wages Receivable control account, which is classified as an asset).
Create a Receipt for the gross amount of the pay stub, received in the bank account and with a single line item for Wages Receivable pointing to the appropriate Sales Invoice.
Create a Payment from the bank account with multiple line items representing each withholding, each line pointing to an expense account.
This seems to me like it should work, yet the trial balance is unbalanced and I’m not sure why (seems to be coming from the Retained Earnings account). Is there something missing or incorrect in the workflow? Do I need to use the Withholding Tax option instead?
Looking through the General Ledger Summary report and going through the transactions for the Retained Earnings account, it looks like there are debits in the amount of the Billable Time that total the exact amount the trial balance is off on the debit side. Could this be a bug with Billable Time? Or am I missing something with how Billable Time is supposed to work?
Ok, I’ve gone ahead and made a test business to reproduce and isolate the issue. I have the .manager file, but I can’t upload it here. May I send it to you another way?
Also, I misspoke earlier. The difference is not the amount in Billable Time. It’s the total of all of the invoices based on that billable time.
In the test file, I have 2 billable time entries for $100 and $200. The invoices are $150 and $250, respectively. The trial balance is off by $400.
Update: I just figured out what is causing the bug. It’s related to using a control account for the Customer of the Sales Invoice. I was using the Wages Receivable control account, but if I remove that (using the base Accounts Receivable), then the Trial Balance and P&L both show the correct amounts.
It seems that using a Customer control account means that Manager no longer creates the “Billable time - invoiced” and “Billable time - movement” entries in the P&L, which means the Trial Balance is off.
