[Feature] Profit and Loss, General Ledger by Period, and Balance Sheet models based on cash accounting method

[fivetran-avinash]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Currently we have set up our Quickbooks Profit and Loss statement, General Ledger by Period and Balance Sheet models to use the Accrual method rather than the Cash Accounting method. This is because Accrual is GAAP approved, while Cash Basis is not.

Accrual is generally the preferred method because it provides a more accurate view of finances, while also factoring in accounts receivable and payable, but we do know that small businesses would prefer to use cash basis.

We'd love to hear from customers as to whether setting up equivalent models that rely on cash accounting would be something you'd be interested in!

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance and will schedule time during your office hours for guidance.
• No.

Anything else?

No response

[davyarnold]

@fivetran-avinash Thank you for looking into this. This would be a huge help for our current accounting methods. I'm sure we will move towards accrual at some point but in the meantime I'm trying to build out some reports for the end of the year using this transformation and I'm getting stuck. Thank you!

[themightychris]

Definitely!

[brandonrf94]

Hi @fivetran-avinash - we've had 2 of our customers ask for this in the last week :(

[fivetran-avinash]

Hi @davyarnold , @themightychris and @brandonrf94 , thanks for letting us know! We'd love to know if any of you would be willing to collaborate on building these models or chip in to submit a PR on what would work best for this approach. Most of our previous scoping has been centered around the accrual methods so we could use anyone's help in how to best build out support cash accounting models.