Accounting mailing list archives

accounting@odoo-community.org

Avatar

Re: Financial Reports

by
ForgeFlow, S.L., Jordi Ballester Alomar
- 16/05/2016 11:53:20

Hi Eric,

MIS should work for that. Define separate query for AP and AR account moves, using the due date as key to determine the periods.

This will easily let you determine your projected inflows and outflows.

If you need projections for other account peraphs you should consider to build an accounting forecast model, that would simply allow you to indicate the future state of an account on a future date.

Then you'd query this model in MIS builder.

El 15/5/2016 22:22, "Eric Caudal" <eric.caudal@elico-corp.com> escribió:

Hi Jordi,
Actually not exactly: the document you present is an accounting document (past oriented) which is absolutely necessary (and MIS Builder is definitely the tool for it) but this is not what I meant:
I need a future oriented report (monthly cashflow projections) based on expected revenue/expenses (from AR/AP). In small/trading businesses, AR/AP is usually enough to get a sense of the cashflow.
This is based on this (http://www.nolo.com/legal-encyclopedia/free-books/small-business-book/chapter14-3.html) but even simpler. It could be based on draft accounting lines with future dates.

I will try to see if MIS can solve this as well.
Thanks !

--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore) Odoo Gold Partner, best Odoo Partner 2014 for APAC
On 05/16/2016 09:53 AM, Jordi Ballester Alomar wrote:
<blockquote cite="mid:CALVkZEevjw0JahWP0JfTMDbuvvO5PcfBm6r8Q-qTg0a40CkQbQ@mail.gmail.com" type="cite">
Hi, when you mean cashflow statement, can you provide an example? Would this be partner-specific?

What I understand as cashflow statement is a financial statement used by the company for internal purposes, at the same level as the Balance Sheet or Profit & Loss. See: https://en.wikipedia.org/wiki/Cash_flow_statement. Is this what you mean? In that case, I have implemented it using MIS Builder, and works great.

Regards,
Jordi.


On Mon, May 16, 2016 at 3:08 AM, Eric Caudal <eric.caudal@elico-corp.com> wrote:

Hi Jordi,
I agree with you with the following addition: most of my small customers need a simplified cashflow statement which is a mix of AR+AP+liquidity beginning balance and calculation of the intermediate balance.
I don't know if this is part of the roadmap but it should notbe difficult to extend from the current AR/AP reports, mixing them group by currency and adding a line for liquidity + calculation of expected balance.

Anyway: good job overall :)

--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore) Odoo Gold Partner, best Odoo Partner 2014 for APAC
On 05/16/2016 06:22 AM, Jordi Ballester Alomar wrote:
<blockquote cite="mid:CALVkZEdgZ0dgUuP3QwttMsJ1QokBKCsGSGWWJD1_ccevGHOQUg@mail.gmail.com" type="cite">
Dear OCA accounting experts,

During and after the Sorrento code sprint I've been thinking and working on the following reports:
  • Partner Balance
  • Partner Ledger
  • Open Invoices
  • Partner Aging
The report "Open Invoices" in v8 looks much like the Partner Ledger, and the work that was done in Sorrento was heading towards this direction, showing debit, credit, balance,... However this does not make sense to me at all, because this is reproducing the Partner Ledger. 

IMHO there should be the following reports:
  • Partner Ledger
  • Partner Balance - summary of Partner Ledger
  • Partner Aging
  • Partner Aging Balance - - summary of Partner Aging

The Partner Aging should really reflect what are the Accounts Receivable and Accounts Payable move lines that have due amounts at a given date, and should tell, at that date, what is/was the due amount, when it is due, and the accumulated totals by partner and currency. Even should show a break down by number of days due.

The Partner Aging Balance should just be a summation of the Partner Aging at the partner level, but showing the same information.

Find attached the proposed report, as it is being implemented here (still called open invoices in the code):

Important remark: The current code supports the computation of the AR/AP items due and the due amount, at the date provided in the report, which is a significant improvement over the standard reports of Odoo v9.

Please let me know your thoughts.

--

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe




--

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe

Reference