Customer Account Statement

by
Odoo

54.12

v 14.0 Third Party 91
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Lines of code 4159
Technical Name sh_customer_statement
LicenseOPL-1
Websitehttps://www.softhealer.com
Versions 17.0 16.0 11.0 14.0 13.0 12.0 15.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Invoicing (account)
Discuss (mail)
Lines of code 4159
Technical Name sh_customer_statement
LicenseOPL-1
Websitehttps://www.softhealer.com
Versions 17.0 16.0 11.0 14.0 13.0 12.0 15.0
logo
Enterprise Community Odoo.sh

Customer Account Statements

The account statement is the summary report of the financial activities. Statements show how much money is spent within a specific time period. An account statement is basically an overview of your financial performance. The statement is one type of tool for customers. Customers can track their paid amount.

This module allows customers to see statements as well as overdue statement details. You can send statements by email to the customers. You can also see customers mail log history with statements and overdue statements. You can also send statements automatically weekly, monthly & daily using cron job. You can filter statements by dates, statements & overdue statements. You can Also filter statements based on their configuration, such as Not Paid, In Payment, Paid, ETC... You can group by statements by the statement type, mail sent status & customers. You can print statements and overdue statements.

Why account statement is important?


The importance of account statements is that show everything about transactions, like date, due date, total amount, paid amount & balance. The statements can be used when we have a misunderstanding or miss management about our transactions. The account statement's purpose is to review your account transactions that where you spent your money and how much money you spent.

Key Features


Hot Features


Dates Wise Filters
Payment Status Filters
Don't Send Mail If Invoice Paid
Customer Statement Whatsapp
Account Statement XLS Report
XLS Report At Portal
Customer Statements
Customer Overdue Statements
Customer Portal Statement
Statement Log History
Filter Statements
Group By Statements
Send Statements By Email
Overdue Statements By Email
Print Statements
Print Overdue Statement
Statement Auto Send
Overdue Statement Auto Send

Account Statamenet Configurations.



Configuration for filter account due/overdue statement records.


Customer Filter Statement Flow

Go to the customer => customer statement.


You can filter statements by dates, so select date and press "Get Customer Statement".


You can send filter statements by mail, so press "Send Filter Customer Statement" and press "Print Filter Customer Statement" to print filter customer statement.


Customer filter statement sent by mail.


Email statement form view.


You can see the statement attachment from an email.


The statement looks like this.


Customer Statement Flow

Go to the customer => customer statement, press "Send Customer Statement" to send the statement by mail and press "Print Customer Statement" to print the statement.


Customer statement sent by mail.


Email statement form view.


You can see the statement attachment from an email.


The statement looks like this.


Customer Overdue Statement Flow

Go to the customer => customer statement, press "Send Overdue Customer Statement" to send the statement by mail and press "Print Overdue Customer Statement" to print the statement.


Customer statement sent by mail.


Email statement form view.


You can see the statement attachment from an email.


The statement looks like this.


Customer Account Statement/Overdue Statement Mail Log History Flow

The statement log history configuration, you can see mail log history from the "See all mail log history".


The statement log history tree view.


Statement log history form view.


You can filter statements by the provided filter list.


You can group by statements by the provided group by list.


Customer Statement Quick Send & Print Flow

You can print statements from the "Action".


You can send a statement/overdue statement from the "Action" button.


Customer Auto Send Statement/Overdue Statement Flow

Customer auto-send statements/overdue statements configuration.


You can daily auto-send customer statements.


You can weekly auto-send customer statements.


You can monthly auto-send customer statements, you can select monthly days.


You can auto-send customer statements by end of the month.


You can yearly auto-send customer statements.


You can send statements by scheduled action(cron job).


Customer Portal Statement Flow

First, you have to give portal access.


Tick "In Portal" in the contact list to give portal access.


Now tick "Show Customer Statement Menu In Portal".


After go to the portal => customer statement.


You can download customer statements from the portal.


You can download customer overdue statements from the portal.


You can send customer statements from the portal.


It shows a popup after successfully send customer statements.


The statement sent by mail.


Email statement form view.


You can see the statement attachment from an email.


v 14.0.14

Go to invoice setting >> Enable the 'Account Statement Auto Send Configuration' according to your preferences.
Select the "Filter Only Unpaid, Send nothing if all invoices are paid."


Here, you can see the customer form view.
In the customer statement tab, you have the option to filter customer statements based on specific time periods, such as monthly, quarterly, yearly, or custom.


In the customer statement tab, you can filter customer statements based on their configuration, such as Not Paid, In Payment, Paid, ETC...


v 14.0.10

Get statement with opening balance & advance payment.



v 14.0.6

In "User", enable the "Send Customer Statement By Whatsapp Feature" option.


Whatsapp message description with the configuration setting.


Set the signature in the message,
1) Go to Preferences.


2) Add Signature.


Add number in the "Mobile" field.


Click the "Send By WhatsApp" Button.


Choose recipient and edit message as required and click send by WhatsApp.


This is the output shown in the WhatsApp messenger.




In the chatter, you can see the message which is sent.


v 14.0.2


You can print an XLS report of the customer filter statement.


Customer filter statement XLS report looks like this.


You can print an XLS report of the customer statement.


Customer statement XLS report looks like this.


You can print an XLS report of the customer overdue statement.


Customer Overdue statement XLS report looks like this.


You can download the customer statement XLS report from the portal.


You can download the customer overdue statement XLS report from the portal.

Version 14.0.15 | Released on : 27th June 2023

  • Fixed Minor Bug Fixed.

Version 14.0.14 | Released on : 16th May 2023

  • New Added Payment Status & Dates Wise Filters
  • New Added Config For Don't Send Mail If All Invoices Are Paid.

Version 14.0.13 | Released on : 8thNovember 2022

  • Update Updates Based On Latest Odoo Patches.

Version 14.0.12 | Released on : 12thAugust 2022

  • New Customer Account Statement Configuration Added.

Version 14.0.11 | Released on : 2ndJune 2022

  • New Filter Statement Between Two Dates Feature Added At Portal Side.

Version 14.0.10 | Released on : 22nd March 2022

  • New Advance Payment & Opening Balance Part Added In Statements.

Version 14.0.9 | Released on : 15th February 2022

  • Fixed Minor Bug Fixed.

Version 14.0.8 | Released on : 20th November 2021

  • Fixed Email Template Issue Fixed.

Version 14.0.7 | Released on : 2 September 2021

  • Fixed Minor Bug Fixed.

Version 14.0.6 | Released on : 27 July 2021

  • New Whatsapp Feature Added.

Version 14.0.5 | Released on : 27 May 2021

  • Fixed Minor Bug Fixed.

Version 14.0.4 | Released on : 30 April 2021

  • Fixed Minor Bug Fixed.

Version 14.0.3 | Released on : 9 April 2021

  • Fixed Minor Bug Fixed.

Version 14.0.2 | Released on : 26 March 2021

  • New You can print customer statement/overdue statement XLS Reports.
  • New You can print customer statement/overdue statement XLS report at the portal.

Version 14.0.1 | Released on : 29 January 2021

  • Initial Release.
  • Yes, we provide free support for 90 days.

Multi-Languages


We have added predefined some languages(English, German / Deutsch, Arabic, Spanish / Español, French / Français, Chinese) in module, If you want to add other language you can contact us on support@softhealer.com. We use google translator tools for multi-languages so possible translations can be not accurate. we accept suggest to make more accurate translations also on support@softhealer.com.

english germany arab chinese french Spanish

You May Also Like


Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
This module is beautiful and I suggest adding a few features to make it perfect
by
gavinguo
on 12/9/21, 7:38 AM

 Add details to bills, 

add advance payment information, 

XLS support XLSX is better 

Re: This module is beautiful and I suggest adding a few features to make it perfect
by
Softhealer Technologies
on 12/10/21, 8:17 AM Author

Hello There,

Add details to bills, 
=> Sorry don't get your point, if it's related t vendor than pls check below statement 
https://apps.odoo.com/apps/modules/15.0/sh_vendor_statement/

For both customer & vendor we have : 
https://apps.odoo.com/apps/modules/15.0/sh_account_statement/

add advance payment information,
=> Already our development going on for this. 

XLS support XLSX is better 
=> It can use as xlsx without any issue.