Problem: I have Payable balance and Advance Paid to the same company both of the document are entered in previous period and I cannot change them, and Advance is represented as Mutual Settlement?
Solution:
1) . Suppose that COMPANY AERO has payable balance (Invoice Received from closed period) and Advance Paid represented as Mutual Settlement, these two documents need to be adjusted with each other:
2) . Enter Mutual Settlement document to write off Payable Balance , Transaction Type - Supplier Debt Adjustment, in Account select any PL Income Account:
In Accounts Payable Tab select Payable Invoice received using Pick option:
Once you post Mutual Settlement following transaction will be created:
3) . Create Other Income document to reverse income and close Prepayments to Supplier Account, Transaction Type - Reversal:
in GL Account Cr select Prepayments to Supplier (or any other which is debited in Advance Mutual Settlement) account with company and contract in the dimension;
In Income GL Account Dr select the income account that you've select in Mutual settlement (For Invoice Received write off):
Once you post Other Income following transaction will be created:
4) . Create Register Correction to remove Advance Mutual settlement from the statement:
In Administration section open Register Correction and Create a new document:
In Register Content Settings in Accumulation Register select Accounts Payable:
In order to fill the line you need to check Advance Mutual Settlements record:
The Content should be the same that you've checked in Mutual Settlement Records, but Instead of Expense it will be reversal Receipt Type:
...
Amount - Amount should be equal to the amount entered in Mutual Settlement
4) 5. In Statement of Mutual Settlements, you'll have Company's closed:
And the following transactions will be in Trial Balance as a result:
Thank you for being a FirstBIT customer!