# Savings & Debt (Prototype) - Savings Account Check - Rounding Issues

**URL:** <https://community.tiller.com/t/savings-debt-prototype-savings-account-check-rounding-issues/6097>\
**Category:** Google Sheets\
**Tags:** how-to, troubleshooting, tcs-savings-budget\
**Created:** [November 11, 2020, 3:16pm UTC](https://community.tiller.com/t/savings-debt-prototype-savings-account-check-rounding-issues/6097 "2020-11-11T15:16:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cculber2](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cculber2/32/4099_2.png) [@cculber2](https://community.tiller.com/u/cculber2)\
**Post date:** [November 11, 2020, 3:16pm UTC](https://community.tiller.com/t/savings-debt-prototype-savings-account-check-rounding-issues/6097/1 "2020-11-11T15:16:46Z")

</div>

Good Morning!

I came across a small bug in the determination of underfunded accounts in the case that the account balance and current allocation net out to zero. The sheet will consider the account underfunded in this case. I was able to remedy the issue by adding `ROUND()` functions in the following formulas and making a slight edit to the Savings Account Check banner formula.

**`AZ13` Underfunded Accounts**  
This ensures that there are no micro rounding errors when calculating the difference between account balance and current allocation.

> `=countif(arrayformula(ROUND(AT7:AT-AU7:AU,2)),"<0")`

**`K5` Unallocated**  
Similar to above, this ensures that there are no micro rounding errors when calculating the difference between the selected account balance and current allocation.

> `=if(OR(isblank($J$2),ISBLANK(K4)),IFERROR(1/0),ROUND($K$3-$K$4,2))`

**`K1` Savings Account Check**  
The formula has been tweaked to include an unallocated amount of $0 in the “good” savings account check status.

> `=if(isblank(J2),"Savings Account Check",if(K5>=0,"👍👍👍 Savings Account Check 👍👍👍",if(K5<0,"👎👎👎 Savings Account Check 👎👎👎","")))`

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [December 1, 2020, 8:50pm UTC](https://community.tiller.com/t/savings-debt-prototype-savings-account-check-rounding-issues/6097/3 "2020-12-01T20:50:57Z")

</div>

These are great refinements, @cculber2. I’m sorry it took me so long to implement them. They are in the newly-published version 0.66.

I’m happy to see you are using the [Savings & Debt template](https://community.tiller.com/t/add-the-savings-debt-prototype-sheet/5228) and I’m grateful for your keen eye toward making these template better.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [May 31, 2023, 12:32am UTC](https://community.tiller.com/t/savings-debt-prototype-savings-account-check-rounding-issues/6097/5 "2023-05-31T00:32:14Z")

</div>

A post was split to a new topic: [Savings & Debt Template Install Issue](https://community.tiller.com/t/savings-debt-template-install-issue/18123)