fivetran / fivetran/dbt_quickbooks

[Bug] Cash Flow statement is not flipping signs appropriately.

Open
#133 6 comments 0 reactions 0 assignees View on GitHub
error:unforced status:accepted type:bug
Dominant language
No language data
Stars
41
Forks
48
PR merge metrics
No merged PRs in 30d

Description

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Describe the issue

The cash flow statement is looking at the account balances from the balance sheet and not flipping the signs on the appropriate accounts.

For example, an increase in Accounts Receivable month over month would be a negative impact to the Cash Flow statement, however it shows up as a positive impact.

Other accounts such as Accrued Revenue, Prepaid Expenses etc. would also need to be flipped accordingly.

![image](https://github.com/fivetran/dbt_quickbooks/assets/75042460/bbcda19b-e93f-4d45-b34e-12f19896fcc9)

### Relevant error log or model output

```shell
n.a
```

### Expected behavior

Cash Flow statement accounts should have the proper signs to help accurately calculate cash flows.

### dbt Project configurations

std.

### Package versions

std.

### What database are you using dbt with?

snowflake

### dbt Version

std.

### Additional Context

_No response_

### Are you willing to open a PR to help address this issue?

- [ ] Yes.
- [ ] Yes, but I will need assistance and will schedule time during our [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance
- [ ] No.

Contributor guide

No contributing guide indexed for this repository

Research direction

Locate the dbt model that produces the Cash Flow statement and trace how it reads month-over-month balance-sheet account changes. Check the handling of Accounts Receivable, Accrued Revenue, and Prepaid Expenses first; done means the relevant cash-flow impacts use the correct signs and the statement calculates cash flows accurately.

Written by the indexing model from the issue text.

Assessment

Domain
data
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.