fivetran / fivetran/dbt_quickbooks
[Bug] Cash Flow statement is not flipping signs appropriately.
- 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.

### 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