SocrateCloud offers a number of predefined reports that can be used to display open items transactions. The reports can be found in the Open Items menu and can be edited in order to comply with the organization's requirements. Details in Reporting.
(15.09) The report, located in the Open Items -> Cash Management menu displays all the cash journal lines representing receipts and payments, depending on the cash type. The report can be used to display unallocated receipts/payments with with Cash Type = "Invoice".
Report Parameters:
Organization
Statement date - selection interval for cash journal lines;
Cashbook - depending on the selected organization;
Business Partner - selection filter by business partner
Sales Transaction
Yes - displays only receipts;
No - displays only payments
Document Type
Cash Type
Cash Journal
The report displays, depending on the selected parameters, a list of bank statement lines and related information. The report also displays the total initial and final balance for the statement lines displayed.
Parameters - selection filters for bank statement lines: Organization, Account, Statement Line Date
Columns - fields that can be found on bank statement lines:
Invoice - the invoice to which the matching payment is allocated;
Payment Amt, Receipt Amt - transaction amount and type.
The report displays, for a bank account, a list of bank statements or bank statement lines.
Parameters:
Show Details - option for the report to display or not bank statement lines;
Charge - selection filter for bank statement lines (if the statement line is matched with a charge);
Columns - transaction amount (payment/receipt), initial and final balance, business partner and the document or charge to which the matching payment is allocated.
The report displays, depending on the selected parameters, a list of payments and receipts and related information:
Parameters - selection filters for the payments and receipt displayed:
Allocated - option to display only allocated payments/receipts;
Due Date - selection interval for the due date on checks;
Columns - fields that can be found on payments:
Payment Amt - negative for payments and positive for receipts.
The report displays, depending on the selected parameters, a list of invoices to which payments matched with statement lines are allocated.
Parameters - selection filters for the invoices displayed;
Due Date - the invoice due date;
Sales Transaction - option to display only customer or vendor invoices;
Columns - fields that can be found on invoices and the matching statement line date.
The report displays, depending on the selected parameters, a list of payments matched with statement lines and their allocated invoice.
Parameters - selection filters for the payments displayed;
Columns - fields that can be found on payments;
Before Due date- checked if the payment was made before the invoice due date
After Due date- checked if the payment was made after the invoice due date.
The Report displays list of payments, and if applicable, the matching bank statement line and bank account information.
Parameters - value that will be contained by the document number of the payments displayed in the report (e.g. %101% - the number must contain 101);
Columns - fields that can be found found on payments;
Statement Date - the matching statement line date.
The report is used to display the payments registered by each user. This is useful when multiple cashiers register cash payments on the same cash journal.
Depending on the selected parameters, the report will display a list of cash journal lines or payments and related information: the user who registered the payment, payment type, payment method, organization and amount.
The purpose of this report is to highlight the payments and the receipts that a user/cashier does during a time period. The report payment/receipt data from the following documents:
Cash Journal Lines
Payment
Starting with v14.04 SocrateCloud offers two payment reports detailed and grouped by CAPEX-OPEX. Capex-Opex categories and subcategories can be defined for each customer and product. The category selection is done at product level and can be indicated when entering the payment. Open Payments are presented with their category and subcategory. Reconciled payments must be allocated using multiple invoice allocation in order to accurately determine the paid product and CAPEX-OPEX category and subcategory.
Starting with v16.10 the detailed report displays payment amounts both with and without VAT.
The report displays, depending on the selected parameters, a list of allocations, generated for payments and invoices and related information: invoice, payment (cash or bank), amount, write off amount and discount.
Parameters - selection filters for the payment-invoice allocation displayed: Payment, Invoice, Business Partner;
Columns - fields that can be found on payment-invoice allocation records.
The report displays, depending on the selected parameters, a list of unpaid invoices, for which payments were either not allocated or allocated partially.
Parameters - selection filters for the invoices displayed: business partner, invoiced date interval, document type;
Columns - fields that can be found on vendor or customer invoices.
The report displays, depending on the selected parameters, a list of unallocated payments (partially or completely)
Parameters - selection filters for the payments and receipts displayed;
Columns - fields that can be found on payments:
Allocated Amt - the partially allocated payment amount;
Available Amt - the payment amount not yet allocated;
Payment Amt - the total payment amount
Write Off Amt - payment amount registered as a write off;
Discount - payment amount registered as a discount.
The report displays, depending on the selected parameters, a list of payments and receipt without matching bank statement lines. The payments are grouped and totaled by type (payment/receipt), account ando organization.
Parameters - selection filters tor the payments or receipts displayed;
Due Date - selection filters for Check payments;
Exclude Draft Statements - option to check for matching statement lines on "Drafted" bank statements;
Columns - fields that can be found on payments.
The report displays, depending on the selected parameters, a list of open invoices (unpaid) grouped and totaled by business partner.
Parameters - selection filters for the invoices displayed: Organization, Business Partner;
Columns:
Amt - total invoice amount;
Open - invoice amount not paid using corresponding documents (e.g. vendor invoice -> payment, customer invoice -> receipt)
Total Open - invoice amount not paid;
Days due - days passed since the invoice due date.
The Invoice Tax Report and Invoice Tax & Location reports display, depending on the selected parameters, a lists of taxes applied to vendor or customer invoice and the respective amounts.
Parameters - selection filters for the invoices for which tax amounts are displayed;
Tax - if selected, the report will display only amounts related to this task rate;
Columns
Tax - tax rate and tax amount on the invoice;
Taxable Amt - total amount on the invoice to which the tax rate was applied;
Invoice Tax & Location -> Tax Location ID - taken from the business partner address.
The report displays, depending on the selected parameters, a list of check or direct deposit payments and their matching statement line
Parameters - selection filters for the payments or receipts displayed;
Statement Line Date - only payments matched to statement lines up to this date will be displayed
Is Open Amt - option to display only matched or unmatched payments;
Columns:
Amt - total payment amt
Is Open Amt - indicates if the payment is matched;
Statement Line, Statement Line Date - matching statement line and date;
Tender Type - payment method used.
The report displays, depending on the selected parameters, a list of cash payments (cash journal lines), their amount and the allocated invoice.
Parameters:
Account Date - date interval cash journal where the displayed lines are registered;
Charge - only cash journal lines allocated to this charge will be displayed;
Cash Book, Organization - selection filters for the cash book where the displayed lines are registered.
The report displays all the unpaid invoices, highlighting the amounts of the invoices to which receivables/ payables have been allocated. The invoices that have been paid in cash will show up in the Open Items Report until the cash journal has been processed.
Parameters:
Sales Transaction:
"Yes" - only display customer invoices.
"No" - only display vendor invoices.
Days Due (interval) - a negative number will indicate the invoices that are due in the future, while a positive one will indicate the invoices whose due dates are exceeded;
The columns of the generated report indicate:
Business Partner - name of the selected business partner;
Date Invoiced - date of issue of the open invoices;
Doc. No - number of invoice ;
Currency - the currency used for the issued invoices;
Grand Total - invoice amount;
Open amount - the open amount for the invoice that has no allocated payment documents;
for invoices using a currency other than the base currency, the amount displayed in this column will be calculated using the same currency rate as the "Revaluation GL Journal", for the accounting schema associated with the invoice organization;
Allocated Amount - the allocated payment amount of the invoice, including the payment document, irrespective of whether these were actually cashed in or not;
Total Open - the invoice's open amount, including the payment documents that have been allocated to the invoice, but have yet to be cashed in;
Covered Amt. - the total amount of the payment documents that have been allocated to an invoice, but have yet to be cashed in;
Due Date - the invoice due date.
The Open Items History Report, besides providing the open items report functionality described above, allows a specific current date to be used when calculating the invoice due days.
Starting with version 14.03, the open items reports will display the balance broken down on each due date corresponding to the invoices operated with multiple due dates.
The report displays open items (invoices) based on the age. This can be 1-7 days, 8-30 days, 31-60 days, >31 days, >61 days, however you can choose other intervals as well. Then, fill in the fields: Statement date, Currency, Business Partner Group and Business Partner. Check the List Invoices checkbox to indicate that the report needs to list the specific invoices. Check the Sales Transaction checkbox to generate a report that will only include the customer invoices. It is recommended you adjust this report such that the required time intervals for analysis are displayed. The balances shown are at the current date.
Starting with v15.07 the Representative filter has been added, through which the report can be executed only for invoices for this representative. The filter works only if List Invoices is selected!
The report used for the operational control of a business partner balance. You can filter the data by sales or purchase transactions (through the Sales Transaction field). You can compile this report for a certain period of time you want to analyse and the displayed information are: the period's beginning balance, movements and ending balance. The selection filters are:
Organization - mandatory, you can select an organization, a group or all (*);
Business Partner - mandatory, you can select a single Business Partner only;
Transaction Date - used to indicate the period interval you want to run the report on;
Sales Transaction -
Yes = sales only - customer related transactions;
No = purchase only - vendor related transactions;
<nothing> = both transaction types will be listed;
Currency - mandatory, indicate the reporting currency (i.e. the currency used to display all transactions, irrespective of their original currency);
Exclude Voided Documents checkbox - optional, by selecting it, all the voided documents and their pairs will be excluded from the report;
v15.12 - Exclude CEC/BO Uncollected from Balance - if checked, commercial bill payments and receipts will not affect the due amounts if not registered on a bank statement;
The report will take into account the following documents:
Customer Invoices - all the invoices corresponding to the selected business partner, at their current status (at the time the report is compiled);
Receipts - all the receipts corresponding to the selected business partner, excluding the Charges, at their current status, irrespective of the allocations, including the receipt discount amounts;
includes all the effects (checks), no matter if these are past their due date or not and if they have or have not been cashed in at the bank.
Cash Receipts - all the cash journal lines corresponding to the selected business partner, excluding the Charges, irrespective of the allocations, including those from the open cash journals.
Vendor Invoices - all the invoices corresponding to the selected business partner, at their current status;
Payments - all the payments corresponding to the selected business partner, excluding the Charges, at their current status, irrespective of the allocations, including the received discounts on credit;
includes all the effects (checks), no matter if these are past their due date or not and if they have or have not been paid from the bank.
Cash Payments - all the cash journal lines corresponding to the selected business partner, excluding the Charges, irrespective of the allocations, including those from the open cash journals.
Allocations - only those allocations between invoices, used in +/- compensations situations.
Exception: Invalid, In process and Drafted documents will NOT be included in the report!
The report calculates and displays the following information as such:
Due Date
Invoice due date: for the report's lines that display invoices;
Payment/Receipt due date: for the report's lines that display Check type Payments/Receipts;
Commercial Bills - the bank statement date where payments/receipts of this type were registered;
Customer Invoice - invoice total;
Receipt:
Receipt total;
Cash journal line total;
Customer Open Amount
as a beginning balance: sum of the invoices - sum of receipts from before the reporting period;
for the movements: beginning balance + invoice - receipt;
the ending balance will be displayed on the report's last line;
Vendor Invoice
Payment:
Payment total;
Cash journal line total;
Vendor Open Amount
as a beginning balance: sum of the invoices - sum of payments from before the reporting period;
for the movements: beginning balance + invoice - payment;
the ending balance will be displayed on the report's last line;
BPartner Open Amount
always equal to Customer Beginning Balance- Vendor Beginning Balance;
the business partner's ending balance will be displayed on the report's last line;
Doc BaseType (starting with version 13.07):
displays the document base type's name for each report line;
Month and Year (starting with version 13.07):
displays the month and year when the documents were issued. Useful to create subtotals for each month/year when reporting on a bigger period;
Description (starting with version 13.07):
displays the information entered in the Description field on the source documents.
Limitations:
For situations when the selected Business Partner belongs to a hierarchy (father - son, linked partners), the reported values are NOT valid if there are documents allocated between different business partners. In this situation, it is recommended you use the Open Items Report and Business Partner Open Report.
The payments and receipts from the cash journal that are not allocated to invoices or orders are interpreted after the sum's sign (+ receipt / - payment), so that we will never have reversed payments/receipts on the report.
For the situations when the documents are operated on different organizations, in order for the report to be correct, you need to run it on a consolidated level for the respective organizations.
This report is not recommended for Business Partner that have transactions in a foreign currency, or in multiple currencies, since, in this version, the report does not take revaluations into account.
The print format needs to be order by Sequence ONLY, otherwise the intermediate balance will not be correct.
Starting with v16.06 the report will also display transactions corresponding to related business partners, as described below:
the report will display payments/allocated amounts (cashbook + bank payments) corresponding to the related business partner;
the report will display only payments allocated to invoices corresponding to the report business partner;
partner relations are defined in the Partner Relations window. Details in Partner Relations.
The report offers a list of commercial bills (checks (tendertype = k)) from the indicated period in transaction dated or report date, and their respective allocated invoices and allocated amounts.
Note: The Transaction Date and Report Date filters should be used separately
The report is useful when checking commercial bill - invoice allocations. The amounts match the entries posted to the commercial bill accounts (413, 5112)
This report is used by organizations that have joined the VAT split payment mechanism. In this case, in accordance with
the legislation, they must determine the cash receipts (or credit card) and pay VAT amounts from the Cash Book Assets or current accounts to VAT accounts (special VAT accounts)
bank account - current accounts are shown - where there may be collections of recorded card payments(credit card transactions)
cash management - to indicate the CashBook where the "Invoice" transactions are being held.
business partner - optional;
document type - to separately make the check between recipts and payments;
transaction date - to indicate the period of verification.