Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI get the same message "Nothing to import. The account is up to date", yet none of my transactions come through.
WHAT I DID:
Logged into my chase account. Clicked download arrow.
Under file Type I chose - Spreadsheet Excel (instead of QBO).
Under Activity I chose - the date range or statement I needed to download; then Downloaded it.
I then called my accountant and asked her if she could transfer my Excel entries onto my quickbooks since the accountant version has that option and we don't.
If I had QB for windows she could have. She could have transferred the Excel entries by "column" (not individually!!) so it is much faster than you think as there are probably just 4 or 5 columns.
Well, I have MAC. So, this is what my amazing accountant did for me:
She had me go into my excel file that I downloaded from Chase. She told me I could sort the list by category, and then just enter the TOTAL for that category once for the entire month. So I will have 1 fuel charge instead of 50, but that works for me. The only charges I need to individually enter are my INVENTORY. I will get to that.
The last column on the excel download said memo, which is the column I used to label my entries. (You can use the category column if you prefer. It doesn't matter.)
I then typed my "category name" in the "memo" column, naming each as I would in my QB (fuel, meals, office supplies, utilities, contributions, etc.. and INVENTORY) Yours will be different, but you get the jest. Yes, labeling each entry with one of my category names takes a little time, but it is quicker and safer than manually entering ALL charges and vendors names!
I now needed to sort and total out these entries by the "category name".
I am not proficient in excel so I emailed this excel sheet to my accountant now nicely labeled. She sorted the list and totaled out each by my category entry names (I had about 8 categories, but it doesn't matter how many - You know what you need.)
She sent it back to me in 2 minutes time. So now I will manually enter just one entry for each category, (1 fuel entry, 1 meals entry, etc... except my INVENTORY which will each be entered individually because that is how we track our inventory). I will have about 30 entries instead of 300.
Those of you who have thousands, I think this will be very beneficial to you. You know what needs to be individually entered, so make sure you label it however you prefer.
This will save me a few hours and some of you a few days. Hope this helps.
Love my accountant!