Statement Of Account Tab
The Statement of Account provides landlords with a breakdown of all the income and expenditure on their property during a specified period.
In order to enable the Statement of Account report to be used for managing companies using the client transfer method, the following the steps must be configured.
Statement Of Account Tab
Click Admin > General Settings. The General Settings > Statement of Account tab displays.
Exclude transactions involving the deposit bank account and nominal group
When this option is ticked, bank transfers between the default landlord bank account and the deposit bank account will be excluded from the Transferred to Client section (when this section is set to display) and the Amount Transferred to Landlord in the summary section.
Treat bank transfers to/from Landlord bank account as client transfers
When Hide Client Transfer Section In Summary page is unticked, the Transferred to Client section displays bank transfers to and from the default landlord bank account. When the config is set to show the Detailed summary, the Amount Transferred to Landlord in the summary section displays the total of these transfers.
Limit to Rental Invoice bank account
When Limit to Rental Income bank account is ticked, only transactions to/from the company default Rental Account is included in the statement of account.
If the Summary Section in Summary Pages is set to None, only the income, expenditure and arrears (if the arrears config is selected) display on each summary page.
If the Summary Section in Summary Pages is set to Simple, only the income, expenditure, arrears (if the arrears config is selected) and total (income minus expenditure) display on the summary pages.
The Summary Details option is only available when Limit to Rental Income bank account is ticked. When Detailed is selected, the income, expenditure, arrears (if the arrears config is selected) and a detailed summary display on the summary pages.
The summary includes:
- Subtotal = Total Income - Total Expenditure
- Balance brought forward - the Rental Bank Account's bank balance for the unit as of the start date of the report
- Transferred to Landlord - the amount that was transferred from the company rental account to the landlord bank account .
- Payment on account - the amount paid by the company default Landlord Account to the company default Rental Account. Note: If the bank transfers were from the rental account to the landlord, the number will be negative.
- Balance due to client - the company default Rental Account's bank balance for the unit as of the end date of the report.
Use invoice payment date rather than invoice date for Expenditure
This option controls from which date purchase invoices/credit notes will display on the Statement of Account. If this option is ticked, expenses will only display on the statement of account once invoices/credit notes have been paid.
If this option is unticked, invoices/credit notes will only display on the statement of account on the date they were raised.
VAT Amount Should be Displayed in the Summary for Raised This Period
When this option is selected, the Raised Total will be broken down to also display the Raised Net and Raised VAT.
Combine income section amount 'Paid this Period' and 'Paid Arrears' and hide 'Raised this Period'
By default the Income section on the summary page has three columns:
- Raised This Period = the total of invoices whose invoice date falls within the period
- Paid this Period = is the total of invoices that were invoiced since the report's start date and paid within the date range
- Paid Arrears = the total of invoices that were invoiced prior to the date range and were paid within the date range
The details pages contain corresponding Income Raised This Period, Income Paid this Period as well as payments received in arrears during this period, listing the detailed transaction of the summary Raised This Period, Paid this Period and Paid Arrears.
When the option to Combine income section amount 'Paid this Period' and 'Paid Arrears' and hide 'Raised this Period' is not ticked, unpaid invoices are included in the amount Raised this Period.
Ticking this setting changes the income section in the summary page to only display one column for the amount Paid. It excludes unpaid invoices that were raised during this period, and it does not break down what was and was not paid in arrears.
VAT Amount should be Displayed in Income Section for VAT registered landlords
When Combine income section amount 'Paid this Period' and 'Paid Arrears' and hide 'Raised this Period' is ticked, you have the option to display the Paid amount in the Income section by Net, VAT and Total Paid for landlords who are VAT registered.
Title prefix for Income and Expenditure associated with an invoice
This field enables you to add a custom label to indicate that this section only includes allocated income and expenditure.
Title prefix for Income and Expenditure associated NOT associated with an invoice
This field enables you to add a custom label to indicate that this section only includes unallocated income and expenditure.
Header Image
This option enables you to upload your logo to the top of the statement of account.
Only Include Income Payments After They Are Allocated
This option enables you to only display payments once they are allocated to a sales invoice, when the invoice date is within the statement of account date range.
Note: Ticking this option will cause paid income to be filtered by invoice date rather than by payment date.
In the example below, the statement of account date range is 1 January 2020 through 31 January 2020.
In the example below, the statement of account date range is 1 December 2019 through 31 December 2019.
Combine Split Invoice Line Items
Selecting this option displays invoice line items that were split into multiple lines (by making part payments) as one transaction in the report.
Hide arrears section
This option hides the arrears sections for the summary and details pages where invoices were raised during the statement of account period and overdue during the period.
Hide Client Transfer Section In Summary page
When this config is set, both bank transfers treated as client account transfers (when this config option is set) and management fees raised as client account transfers (when this config option is set), will not be included in the statement of account.
Each Tenant of a Unit Should Display Separately
This option is only available in specific circumstances as a bespoke option from some customers. Statement of Account - Each Tenant of a Unit Should Display Separately







0 Comments
Add your comment