Difference between revisions of "Reconciliations between companies"
| Line 1: | Line 1: | ||
| − | __FORCETOC__ |
||
<translate> |
<translate> |
||
| + | == Reconciliation between companies / Internal reconciliations== |
||
| + | ''Accounting/Reports'' |
||
| + | In the report Reconciliation between companies under Accounting | Reports, internal transactions are reconciled. |
||
| − | = Reconciliations between companies = <!--T:1--> |
||
| ⚫ | It shows whether an invoice sent from company A exists in company B and whether the outstanding amount is the same. Liabilities and receivables between companies that are recorded in special balance sheet accounts, as well as internal sales and internal purchases, are displayed. Internal sales are client invoices excluding VAT, and internal purchases are supplier invoices excluding VAT. |
||
| + | To start using the feature, the following settings need to be made: |
||
| − | <!--T:2--> |
||
| − | ''{{pth|Accounting/Reports/Intercompany reconciliations}}'' |
||
| ⚫ | |||
| − | <!--T:3--> |
||
| − | Internal reconciliations is a tool to check internal dealings. |
||
| ⚫ | |||
| + | # Mark clients and suppliers with counterparts in Accounting |Backoffice |Base registers, the Sales ledger tab and Accounting |Backoffice |Base registers, the Purchase ledger tab, respectively. For example, supplier A in company B should be marked with counterpart A. The marking of suppliers and clients captures supplier invoices and client invoices as well as internal purchases and internal sales. |
||
| − | <!--T:4--> |
||
| − | You need the following settings before you can get started: |
||
| + | # If other internal receivables and liabilities are to be reconciled (shown as G/L Trade debtors and credi-tors in the report), balance accounts for this need to be marked with counterparts in the chart of ac-counts in the respective company. |
||
| − | <!--T:5--> |
||
| − | {|class=mandeflist |
||
| ⚫ | |||
| − | <!--T:6--> |
||
| − | !1. |
||
| ⚫ | |||
| − | |- |
||
| − | !2. |
||
| − | |Tag clients and suppliers with Counterpart in {{pth|Base registers/SL/Clients}} and in {{pth|Base registers/PL/Suppliers}}respectively. Example: Supplier A in companies B and C shall be tagged with Counterpart A. The tag enables finding suppliers' invoices and client invoices as well as internal dealings. |
||
| − | |- |
||
| − | !3. |
||
| − | |If internal dealings shall be handled,(shown as G/L Trade debtors and creditors in the report) you will have to also mark balance sheet accounts with counterparts in each company. |
||
| − | |} |
||
| ⚫ | |||
| − | <!--T:7--> |
||
| ⚫ | |||
| − | <!--T:8--> |
||
| ⚫ | |||
| − | |||
| − | <!--T:9--> |
||
| − | [[Category:Accounting]] |
||
| − | [[Category:Manuals]] |
||
</translate> |
</translate> |
||
Revision as of 10:51, 13 February 2026
Reconciliation between companies / Internal reconciliations
Accounting/Reports
In the report Reconciliation between companies under Accounting | Reports, internal transactions are reconciled. It shows whether an invoice sent from company A exists in company B and whether the outstanding amount is the same. Liabilities and receivables between companies that are recorded in special balance sheet accounts, as well as internal sales and internal purchases, are displayed. Internal sales are client invoices excluding VAT, and internal purchases are supplier invoices excluding VAT.
To start using the feature, the following settings need to be made:
- Check the parameter ” Show in Intercompany reconciliation” on the company in System | Base registers | Companies. Open the company, the parameter is in the Other tab.
- Mark clients and suppliers with counterparts in Accounting |Backoffice |Base registers, the Sales ledger tab and Accounting |Backoffice |Base registers, the Purchase ledger tab, respectively. For example, supplier A in company B should be marked with counterpart A. The marking of suppliers and clients captures supplier invoices and client invoices as well as internal purchases and internal sales.
- If other internal receivables and liabilities are to be reconciled (shown as G/L Trade debtors and credi-tors in the report), balance accounts for this need to be marked with counterparts in the chart of ac-counts in the respective company.
When performing the reconciliation, one company is entered as “Company From” A and the other as “Counterpart” B. The currency should be the company's base currency. It does not matter which company is specified where and in which company the report is run.
If there are differences in the list that appears, you can open the row and view the details, i.e. invoices that differ.
