[Accounting Improvements] Proposal for Foundation Funds for Accounting Improvements

[jai_kejriwal]

The Accounting module would like to present the Accounting team’s proposal for foundation funds for driving improvements.

1. Improved Financial Reporting in ERPNext

   Improved Financial Reporting in ERPNext · Issue #12477 · frappe/erpnext · GitHub
   Accounting Numbering in COA should Determine the Account Position in the Financial Statement · Issue #12360 · frappe/erpnext · GitHub
   Incomplete Mapping in Cashflow · Issue #8109 · frappe/erpnext · GitHub

2. Import Bank Statement #2184
   Import Bank Statement · Issue #2184 · frappe/erpnext · GitHub

3. Cost-Center/Dimensional Trial-Balance and Other Reports
   https://github.com/frappe/erpnext/issues/12596

4. Exact Cost Valuation Method
   [Feature-Request] Exact Cost Valuation Method · Issue #7191 · frappe/erpnext · GitHub

@revant_one Kindly let me know if there is anything else we need to do.

Regards,
Jai

[revant_one]

We’ll select issues,
add or edit specifications, mock-ups and screens on the issues
and set a Foundation Bounty milestone with these issues for Jan 2018.

Any suggestions?

[tmatteson]

My personal order of preference is:

1. 2. Import Bank Statement #2184
2. 3. Cost-Center/Dimensional Trial-Balance and Other Reports
3. 1. Improved Financial Reporting in ERPNext
4. 4. Exact Cost Valuation Method

But honestly, all of these are worthy and seem like meaningful features to add. I have two contributions I’ve been working on that I’d like to add as well: a book-to-bank style bank reconciliation alongside the existing one and the non-depreciable asset additions. I need to re-read the contribution guidelines and probably get some help on this; @tundebabzy was great about dealing with my newness and general disorganization.

[jai_kejriwal]

We need cost-center wise trial balance and other statements/reports for a full migration to ERPNext and are willing to contribute another $500 to this effort.

Can we get the extended community involved in raising some more $$ for this foundation-led improvement effort?

[revant_one]

Good Candidates :

Accounting Numbering in COA should Determine the Account Position in the Financial Statement

Accounting Numbering in COA should Determine the Account Position in the Financial Statement

Total 7 Thumbs up, 1 comment, Bug Tag
Bug should be solved on priority. Foundation or otherwise.
The issue is already assigned to @nabinhait

1. Import Bank Statement
   Import Bank Statement · Issue #2184 · frappe/erpnext · GitHub
   pending since Sept 2014, has todo checklist.
   Good candidate with specifications and discussion

2. Incomplete Mapping in Cashflow
   Incomplete Mapping in Cashflow · Issue #8109 · frappe/erpnext · GitHub
   1 Comment, 1 Thumbs up, Feature Request, Mar 2017
   sample cashflow template shared. needs review and approval for cashflow template.

3. [Feature-Request] Exact Cost Valuation Method
   [Feature-Request] Exact Cost Valuation Method · Issue #7191 · frappe/erpnext · GitHub
   0 Comments, 0 Thumbs Up, Dec 2016
   Issue described in detail points, This seems a major change. Any comments from @nabinhait

4. Cost-Center (Dimensional) Trial Balance and Other Financial Reports
   https://github.com/frappe/erpnext/issues/12596
   0 Comment, 1 Thumbs Up, created 23 hours ago,
   Youtube video demo of Sage Intacct, if someone can interpret the video in context to ERPNext along with screens on the issue. It will be good candidate with clear specifications if there are screenshots. I think it will be difficult for developers to play back and forth through video many times.

Need more details :

1. Improved Financial Reporting in ERPNext
   Improved Financial Reporting in ERPNext · Issue #12477 · frappe/erpnext · GitHub
   4 Thumbs up - no specific comments, 9 days ago
   I think this needs more discussion, specification, sample reports expected.

[jai_kejriwal]

I have updated the Github Issue related to Trial Balance by Cost Center with some QuickBook screens which should help.

[tmatteson]

Here’s the Bank Reconciliation improvements (well, I think they’re improvements but they don’t change anything for the folks doing it now, as-is. I’m looking for some help understanding why the SQL lookup is being weird.

Bank Reconciliation Book-to-Bank functionality

Here’s a brief video of the book-to-bank functionality I’ve added. Why? Because I’m used to reconciling to the net change in cash, not the total of credits and debits. I don’t even think I’ve ever seen a bank statement offers that, but I didn’t want to take it away, because obviously people are using it. This method makes more sense to me and it’s how I learned how to reconcile a bank account. [ERPNext Prototype Bank Reconciliation] So here’s where I’m stuck: I’d like to include so…

[jai_kejriwal]

@nabin @revant_one if you could give a pointer this could be helpful. Only tagging you guys because it’s part of the bank statement improvements.

[tmatteson]

@spoojary (sorry if I’m tagging the wrong person - github handle is sathishpy), are you working on #1? I’d like to help, please DM me so we can collaborate. If you’re close, I’ll move on to another one of these.

[spoojary]

Yes, I have already submitted the pull request for (1). There are some fixes I have made in my local repository, which I will push by weekend. Btw, I have explained all the details in github issue, and it doesn’t cover updating clearance date. Perhaps that is not needed in this model as we are getting the transactions directly from the bank statement.

[tmatteson]

Oh cool! Clearance data should be updated because it’s reliable information coming from an imported bank statement. Is this an enhancement I can help you with? I’ve been working on this recently with the manual bank reconciliation.

I really like your architecture, by the way. Excellent work.