Because of Accounts Payables and Accounts Receivables are default accounts, there is no option to detalise it in balance sheet. Yes, you can click on the amount and detalisation wiil be there. Is there any way to make it detalised by customers/suppliers in balance sheet report?
Is it possible to make AR/AP auto-transferrable. As soon as accounts receivables goes below zero - it automaticly transfers to payables.
As a newcomer to the Manager forum, please note that your first port of call before asking a question should be the guides. How to answer your q1 is explained in detail
I’m going to do this for detailed information about balances with each of buyers/suppliers. Q2 have also resolved by journal entries from AR/AP to custom accounts at the end of the period and cancellation of it on first day of next period (ex. open account with customer and prepayments are more than invoiced goods, AR goes to minus value, because of this I need manualy change the position of this account as payables to this customer and put it to liabilities by journal entry).
Yeah, if PC and Manager is somwhere near - it’s suitable. When printing for someone from manager - it would not be detailed. Consider it like my desire .
Why wouldn’t it suddenly not be detailed? You could copy to clipboard, paste into Excel and print (so not 2022ish) or, even better, print the Customer Statements (Transactions) and/or Supplier Statements (Transactions) report.
I understand such way of solving detalisation question, but in this way I need to recalculate total assets/liabilities. There is two ways how to solve it: custom accounts and excel + manually correction. The time for solving is +/- the same.
As long as you do not have 10s or 100s of customer/supplier this will work but otherwise your Balance Sheet will be more or less unreadable
Also, once the customer/supplier is used, they will continue to be listed in your chart of accounts forever. even long after you no longer do any business with them
A quick chat with your accountant will clarify this
I just changed “detalisation” in the topic title because I do not really know what it means. However I think that you meant to use" detailed overview" which is about getting more details.
Am I correct is assuming you have external entities which are both customers and suppliers? So the report you are looking for shows all invoices with that entity?
If so you are correct that Manager has a work around for this situation but does not really support it. To do so the customer and supplier tables in Manager would need to be linked.
Hi! Not in this way. For example there is one customer with open account. He pays the prepayment. After payment this account is in payables to customers (liabilities). We have dispatched and invoiced goods for the total amount more than the prepayment amount. After this his actual balance in balance sheet is indicated as payables (liabilities) but with negative amount. It is incorrectm thats why I manually transfer the difference from liabilities to assets as account receivable from this customer.