# Need Help Creating a Monthly Credit Card Only Reconciliation Template

**URL:** <https://community.tiller.com/t/need-help-creating-a-monthly-credit-card-only-reconciliation-template/8022>\
**Category:** Google Sheets\
**Tags:** google-sheets, how-to, tracking, advice, tcs-addon\
**Created:** [March 14, 2021, 4:05am UTC](https://community.tiller.com/t/need-help-creating-a-monthly-credit-card-only-reconciliation-template/8022 "2021-03-14T04:05:19Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![jono](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jono/32/283_2.png) [@jono](https://community.tiller.com/u/jono)\
**Post date:** [March 14, 2021, 7:10pm UTC](https://community.tiller.com/t/need-help-creating-a-monthly-credit-card-only-reconciliation-template/8022/2 "2021-03-14T19:10:47Z")

</div>

Hi @alondc ,  
I don’t think there are any templates that match exactly what you are doing. But using some Google Sheet formulas, you should be able to build everything you are looking for.

See this for how to add new automatic columns to your Transaction sheet based on just one formula at the top of the sheet:

> [@Adding New Columns On The Transaction Tab Automatically](https://community.tiller.com/t/adding-new-columns-on-the-transaction-tab-automatically/6586):
>
> Hi all, I was wondering if someone knew the workaround add-in certain columns to the transactions tab automatically. Currently, I am manually adding columns O and R with a Vlookup that I have to drag up every time new data is added in. This tells me what type of category it is and then goes down to another sub-level that I then use for data manipulation later. I think I’m just going blank because I know that this can be done automatically but not sure how. Can anyone help? (I would embed an …

You should also look into the [SUMIFS](https://support.google.com/docs/answer/3238496?hl=en)() formula in addition to SUMIF().

You might also use the [FILTER](https://support.google.com/docs/answer/3093197?hl=en)() function to import the list of expenses that match your criteria.

Hopefully that will get you started.

Jon

---

_[View the full topic](https://community.tiller.com/t/need-help-creating-a-monthly-credit-card-only-reconciliation-template/8022)._
