PT
ES
AO
CV
MZ
Professional
Executive
Public Sector
Omnia
Evolution
In PAA, you can perform bank posting reconciliation and posting operations in a single menu, available in Workspace | [Client] | Banks Actions Menu | Reconcile/Post.
This menu consists of the following tabs/information:
Period data and summary;
Bank reconciliation;
Post transactions;
Bank statement;
Discarded postings.
Period Data and Summary
Search filters
In the reconciliation data, you can specify the client, the bank account, and the period of the reconciliation.
Opening Balances
Here you can view the reconciled and not reconciled amounts from previous periods:
Not Reconciled: shows the not reconciled balances prior to the Start Date and End Date set;
Rec. in Period: shows the previous not reconciled balances that were reconciled within the set period.
Postings for the Period
Here you can view the reconciled and not reconciled amounts for the set period:
Not Reconciled: shows the not reconciled balances for the period;
Difference: shows the difference between the not reconciled balances for the period;
Reconciled: shows the reconciled balances for the period;
Rec. in Other Period: shows the balances for the period that were not reconciled here but were reconciled in other periods.
Closing Balances
Here you can view the final reconciled and not reconciled amounts for the set period:
Not Reconciled: shows the not reconciled balances at the end of the period;
Difference: shows the difference between the not reconciled balances at the end of the period;
Reconciled: shows the reconciled balances at the end of the period.
Bank Reconciliation
This tab consists of three areas:
Reconciliation criteria
Match Criteria: lets you set a group of criteria to be used when comparing the bank statement with accounting:
- Bank Statement Date: lets you select which bank statement date to consider in the analysis (Posting Date or Value Date);
- Accounting Date: lets you select which accounting date to consider in the analysis (Date or Doc. Date);
- Day: if selected, the days of the dates set above will be compared;
- Month: if selected, the months of the dates set above will be compared;
- Year: if selected, the years of the dates set above will be compared;
- Amount: if selected, the bank posting's amount and the accounting amount will be compared;
- Tax ID: if selected, the third party's Tax IDs will be compared, assigning the bank posting through a pattern and through accounting;
- Description: if selected, the bank posting's description and the accounting description will be compared;View Status: lets you filter the statement entries based on the match obtained (Full, Partial, or No Match);
Sum of Matches: shows the sum of the matched amounts from the bank statement and from accounting. A reconciliation can only be performed when the difference between these amounts is 0.
Bank statement
This area shows all the pending postings for the selected bank account and period.
Accounting statement
This area shows all the not reconciled accounting postings for the selected bank account and period.
Posting Transactions
On the Post Transactions tab, you can integrate bank postings directly into accounting. In addition to posting, this operation will also automatically reconcile the bank posting.
In this grid, you can view the pending postings from the bank statement, as well as the posting parameters, i.e., the account to post to, the journal, the accounting document, and the template to be used for the posting. These parameters can be entered manually or automatically by the bank pattern assigned to the posting; however, they can also be filled in manually.
Bank Statement
This tab consists of three areas:
Bank statement: you can view all the postings for the selected bank account and period, as well as their respective status;
Reconciled documents: selecting a bank statement posting with a status of Reconciled or Posted will show the accounting documents reconciled with the selected posting;
Accounting posting: selecting an accounting document reconciled with a bank posting will show the various postings that make up the selected document. In this grid, you cannot edit the accounting document.
Discarded Postings
On this tab, you can view discarded bank postings and restore them, if necessary.
Context Menu
In this menu, you can perform the following operations:
Multiselect (Ctrl+M): enables multiselection in the grids;
Reconcile (Ctrl+R): saves the changes made. The document is not integrated into the ERP;
Undo (Ctrl+L): undoes all automatic and/or manually created matches;
Discard (Ctrl+D): saves the changes and closes the menu. The document is not integrated into the ERP;
Update (F5): updates the reconciliation and posting data;
Reprocess Patterns (F6): reprocesses the bank patterns;
Integrate ERP (Ctrl+I): integrates the selected bank postings into the ERP's accounting;
Cancel Reconciliation (Ctrl+Shift+R): cancels the reconciliation of the selected bank postings;
Cancel Integration (Ctrl+Shift+I): cancels the posting of the selected bank postings;
Cancel Discard (Ctrl+Shift+D): cancels the discarding of the selected bank postings.
Save: Saves the data entered in the Description field on the Post Transactions tab.
The actions shown here vary depending on the tab selected.