Accounting mailing list archives
accounting@odoo-community.org
Browse archives
Re: Financial Reports
byActually 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
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 APACOn 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.--Jordi Ballester AlomarCEO & Founder | EficentTwitter: https://twitter.com/jbeficent_erp | Linkedin: https://www.linkedin.com/in/jordiballesteralomar_______________________________________________
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
