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:
...
Contract - Company contract (Copy from Mutual Settlement)
Document - Mutual Advance Mutual Settlement
Is Loan - No
GL Account - Prepayment to Suppliers (Copy from Mutual Settlement)
Amount - Amount should be equal to the amount entered in Mutual Settlement
3) In order to create the GL entry open Transactions (General Ledger) in Accounting section and create a new one:
In Dr column select Owner's Current account (BS Capital Issued) and in Cr column select Prepayments to Suppliers (BS Trade and Other Receivables) or other GL account that was select in Accounts Payable Tab of Mutual Settlement document:
4) 5. In Statement of Mutual Settlements, you'll have Payable amount on this Company's accountclosed:
And the following transactions will be in Trial Balance as a result:
Thank you for being a FirstBIT customer!