I started using Manager about 6 months ago for my Rental Property Accounting. I have a mixed Accrual and Cash based accounting system. Official reporting is Cash based but I use Lease Accounts to track tenant payments and obligations. The accounting was original setup in Quicken (bookkeeping was very difficult, reporting was serviceable), and subsequently transferred to GNUCash (accounting was serviceable but reporting was a nightmare).
So, far I’m extremely happy with Manager. Once you understand the logic of the implementation it is very easy to use and extremely flexible. I have been able to implement nearly all the aspects of my accounting and reporting system as well as add functionality that was previously overly difficult or unavailable.
I have run into one issue which I’m hoping the community can help me solve. As stated above, I use a mixed accrual and cash-based system. In Manager, I’m using the customer/invoice functionality to manage my lease accounts. Then I select cash-based accounting for my reports. I’ve figured out how to make this work for my PL, Balance and Cash Flow Reports, but I’m having issue with my PL Transaction Report.
The PL Transaction Report should show the individual transactions which contributed to the Profit Loss Statement. I’ve had to generate this report using the Custom Report functionality. My issue is with the way Manager handles converting Invoiced Payments to Cash based transactions. Cash based accounting is accomplished by first accruing every invoice and then adding a cash-based adjustment. The cash-based adjustment sums all invoices which were unpaid in the accounting period.
This works perfectly for the PL Summary Report but in my Custom PL Transaction Report I end up with a list of transaction which include additions and subtractions from unpaid or partially paid invoices from previous periods. Furthermore, invoiced transactions are accounted on the date of the invoice instead of the date of payment/receipt.
I understand the logic behind the output and the sum of each category is correct for cash-based accounting. However, technically speaking this is NOT cash based accounting. The date of the transactions has been reported incorrectly as the date of the invoice instead of the date of the payment/receipt.
Is there a way to create a report which will account for these transactions on the date of the payment/receipt instead of the date of invoice? Please let me know if I’m using the program wrong. I’m willing to change my accounting system to better work with the program.
Furthermore, when you order custom reports by a date, transactions are sorted as if the date is a number instead of a date. So all the December transactions are last without regard to the year.
