--- title: "Accounts Reconciliation Scenarios" canonical: "https://wiki.soft1.eu/space/SS5EN/189268771/Accounts%20Reconciliation%20Scenarios" format: markdown --- --- --- #### Indicative Reconciliation Scenario | | | | | --- | --- | --- | | **STEPS** | **BROWSERS** | **FILTERS** | | | **Description** | **Name** | **Sign** | **Field** | **Description** | **Field** | **Expression** | | Account | Field | Sign | Participation | | | | | | 70 | Balance (Credit-Debit) | Positive | Always | | | | | | 71 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.22 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.24 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.25 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.26 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.28 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.00 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.10 | Balance (Credit-Debit) | Positive | Always | | | | | | 72.11 | Balance (Credit-Debit) | Positive | Always | | | | | s | | | | | | | | | | --- | --- | --- | --- | --- | --- | --- | --- | | > Macro (nested-table) | Sales of Goods | Sales statistics | Positive | SALVAL | Type of materials | MSODTYPE | 51 | | Services provision
> Macro (nested-table) | Services provision | Sales statistics | Positive | SALVAL | Type of materials | MSODTYPE | 53 | | Other Revenue
> Macro (nested-table) | Other Revenue | Expenses / Debits-Credits Statistics | Positive | EXPVAL | Module | SOSOURCE | 1353 | | Outflow VAT (sales)
> Macro (nested-table) | Outflow VAT (other revenue) | Expenses / Debits-Credits Statistics | Positive | IMPVATAMNT | Module | SOSOURCE | 1351 | | Outflow VAT (sales of goods) | Sales statistics | Positive | SALVATAMNT | Type of materials | MSODTYPE | 51 | | Outflow VAT (services provision) | Sales statistics | Positive | SALVATAMNT | Type of materials | MSODTYPE | 53 | | Domestic Purchases
> Macro (nested-table) | Purchases | Purchase statistics | Positive | PURVAL | Type of materials | MSODTYPE | 51 | | Type | FPRMS | #2000,2001,2021,
2031,2032,2033,
2041,2042,2044,
2045,2061,2062,
2065,2066,2069,
2151,2162,2261,
2717,9242 | | Intra-EU Purchases
> Macro (nested-table) | Intra-EU Purchases | Purchase statistics | Positive | PURVAL | Type | FPRMS | #3263,3267,3281,
3283 | | Purchases - Imports from Third countries
> Macro (nested-table) | Purchases - Imports from Third countries | Purchase statistics | Positive | PURVAL | Type | FPRMS | #3262,3264,3268,
3282,3284 | | Fixed Asset Purchases
> Macro (nested-table) | Fixed Asset Purchases | Purchase statistics | Positive | PURVAL | Type of materials | MSODTYPE | 54 | | Inflows VAT (purchases)
> Macro (nested-table) | Inflows VAT (purchases) | Purchase statistics | Positive | PURVATAMNT | Module | SOSOURCE | 1251 | | Expenses
> Macro (nested-table) | Expenses (Other transactions) | Expenses / Debits-Credits Statistics | Positive | IMPVAL | Module | SOSOURCE | 1253 | | Type | FPRMS | #1001,1002,1003,
1004,1005,1006,
1007,1010,1101,
1102,1103,1104,
1105,1106,1107,
1301,1302,1303,
1304,1331,1401,
1402,1403,1404,
1405,1431,1501,
1601,3001,3002 | | Inflows VAT (expenses)
> Macro (nested-table) | Inflows VAT (expenses) | Expenses / Debits-Credits Statistics | Positive | IMPVATAMNT | Module | SOSOURCE | 1253 | | Customers
> Macro (nested-table) | Customer balance | Customer transactions with cheques analysis | Positive | LBALANCE | Company | COMPANY | 1000 | | Debtors
> Macro (nested-table) | Debtor balance | Debtor transactions with cheques analysis | Positive | LBALANCE | Company | COMPANY | 1000 | | Suppliers
> Macro (nested-table) | Supplier balance | Supplier transactions with cheques analysis | Negative | LBALANCE | Company | COMPANY | 1000 | | Creditors
> Macro (nested-table) | Creditor balance | Creditor transactions with cheques analysis | Positive | LBALANCE | Company | COMPANY | 1000 | | Cash
> Macro (nested-table) | Cash balance | Cash accounts transactions with cheques analysis | Positive | LBALANCE | Account nature | TRDR_BANKACC_TRDTYPE1 | 1 | | Current account
> Macro (nested-table) | Current account | Cash accounts transactions with cheques analysis | Positive | LBALANCE | Account nature | TRDR_BANKACC_TRDTYPE1 | 5 | | Checks receivable
> Macro (nested-table) | Checks receivable | Cheques | Positive | balance | Type of cheque | CHEQUETYPE | 1 | | Checks payable
> Macro (nested-table) | Checks payable | Cheques | Positive | balance | Type of cheque | CHEQUETYPE | 2 |