# Manually Imported Bank Transactions Issues **URL:** \ **Category:** Google Sheets\ **Tags:** troubleshooting, tcs-business\ **Created:** [September 30, 2019, 2:57pm UTC](https://community.tiller.com/t/manually-imported-bank-transactions-issues/576 "2019-09-30T14:57:49Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![fitnesscoach](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/fitnesscoach/32/615_2.png) [@fitnesscoach](https://community.tiller.com/u/fitnesscoach)\ **Post date:** [September 30, 2019, 2:57pm UTC](https://community.tiller.com/t/manually-imported-bank-transactions-issues/576/1 "2019-09-30T14:57:49Z")
Hi. I manually imported my bank data according to these instructions. However my insights and dashboards tabs, are missing data and tables of the transactions. Please see the attached. What am I doing wrong or how can I fix this? Thanks! ![39%20AM](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/1X/d496d4942ddf432d0ee85240369584d537beccb8.png) ![20%20AM](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/1X/000db4fee447abe6e56fb88b60658199e655c9dd.png) ---
**Author:** ![fitnesscoach](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/fitnesscoach/32/615_2.png) [@fitnesscoach](https://community.tiller.com/u/fitnesscoach)\ **Post date:** [September 30, 2019, 3:01pm UTC](https://community.tiller.com/t/manually-imported-bank-transactions-issues/576/2 "2019-09-30T15:01:27Z")
The data that I’m referring to on the first sheet, is the first Columns data! ---
**Author:** ![fitnesscoach](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/fitnesscoach/32/615_2.png) [@fitnesscoach](https://community.tiller.com/u/fitnesscoach)\ **Post date:** [September 30, 2019, 5:42pm UTC](https://community.tiller.com/t/manually-imported-bank-transactions-issues/576/3 "2019-09-30T17:42:27Z")
Ok. I just figured it out. The headers were correct, but the formatting of the pasted data was slightly off. In the First Date column, the format has to be like 9/29/19 3:00:00 and not 9/29/19. FYI! ---
**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:** [October 1, 2019, 4:47pm UTC](https://community.tiller.com/t/manually-imported-bank-transactions-issues/576/4 "2019-10-01T16:47:24Z")
Glad you figured it out, @fitnesscoach. 👍 Randy ---
**Author:** ![Koorius\_G](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/koorius_g/32/982_2.png) [@Koorius\_G](https://community.tiller.com/u/Koorius_G)\ **Post date:** [March 22, 2020, 9:08pm UTC](https://community.tiller.com/t/manually-imported-bank-transactions-issues/576/5 "2020-03-22T21:08:32Z")
Hi I’m using the foundation template and added manually all my transactions for 2018 for all my accounts but the insights tab is not updating or showing me anything? I didn’t link any accounts to this sheet so I didn’t add the account ID or institution and other columns. Do I need to add those for the insights sheet to analyze? The columns I have is Date Description Category Amount. ---
**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:** [March 23, 2020, 4:57pm UTC](https://community.tiller.com/t/manually-imported-bank-transactions-issues/576/6 "2020-03-23T16:57:44Z")
Hey @Koorius_G, Most of the `Insights` sheet data is independent of the `Balance History` or `Accounts` sheets. The Account information only matters in the top-3 balances section or if you are using the Account filter in the Transaction Analyzer. Are you using a custom date range in the Transaction Analyzer to query the 2018 data? How did you move over the data? Manual copy/paste or via the [Tiller Labs importer](https://community.tiller.com/t/how-to-import-csv-line-items-with-the-tiller-labs-add-on/2512)? Randy