Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I would be so grateful for an answer to this one. I have imported a month of transactions but it is recording all income as 0. I have to reimport but can't delete the original. I would be so grateful for support.There is no way to just delete the entries and starting again.
Solved! Go to Solution.
Hi there, Jane.
I'm here to share information about deleting imported data in QuickBooks Online (QBO).
If transactions are imported through online banking, we can exclude and delete the entries. Let me show you how.
Once excluded, these transactions will show up in the Excluded tab, and that's where you can delete them. Here's how:
In addition, here's an article you can read to learn more about excluding your bank transactions: Exclude a bank transaction you downloaded into QuickBooks Online.
On the other hand, if you manually imported your transactions through online banking yu have the option to map the fields correctly before importing the file. Please ensure to review the transactions before uploading.
Lastly, I've also included this helpful article for the steps in case you need to start balancing your account register: How to reconcile your accounts so they always match your bank and credit card statements?
I'd suggest getting back to this thread if you need assistance with your transactions. I'm always here to back you up. Take care and stay safe!
Hi there, Jane.
I'm here to share information about deleting imported data in QuickBooks Online (QBO).
If transactions are imported through online banking, we can exclude and delete the entries. Let me show you how.
Once excluded, these transactions will show up in the Excluded tab, and that's where you can delete them. Here's how:
In addition, here's an article you can read to learn more about excluding your bank transactions: Exclude a bank transaction you downloaded into QuickBooks Online.
On the other hand, if you manually imported your transactions through online banking yu have the option to map the fields correctly before importing the file. Please ensure to review the transactions before uploading.
Lastly, I've also included this helpful article for the steps in case you need to start balancing your account register: How to reconcile your accounts so they always match your bank and credit card statements?
I'd suggest getting back to this thread if you need assistance with your transactions. I'm always here to back you up. Take care and stay safe!
Thank you. I managed to exclude them. Its unsatisfactory somehow because I feel I should be able to delete the whole of September but I am learning. This is so so much harder than using a spreadsheet to do your accounts and I am not yet seeing the advantage yet. I hope it gets easier as spreadsheets import naturally in this financial year.
Imported September again but the income and outgoings were the wrong way around. Now I am confused as to what is a debit and what is a credit. My account is credited with money coming in, and debited with money going out. But in book-keeping its the other way around. Now I am really confused. I have all the others imported correctly but September just is a mess. There is no instruction as to how you should label income and outgoings. I guess I just have to do the opposite of what I just did. Spent 4 hours on just getting September in correctly. And still have not.
Thank you. I managed to exclude them. I am now unsure what is a credit and what is a debit. Credit is income and Debit is outgoing I thought but when i did this all the entries were the wrong way round. Once again I can't seem to create a cvs file. I have to do this several times but the format stays .xls. It is the most frustrating thing. Now I am stuck as I can't get September in Quickbooks.
I'm here to ensure you can import your September transactions, Jane.
Debit and credit accounting have distinct purposes and placements in QuickBooks Online. To ensure the double-entry accounting is added correctly in your transactions, please see this article: How Accounts are Affected by Debits and Credits.
If the file is in XLSX or XLS format, we can save them directly as a CSV copy. For visual reference, I've added a screenshot below.
If you still can't convert it, you may want to consider utilising a third-party app. Aside from CSV, we can also use the following supported file types:
To find an app, I suggest browsing the QuickBooks Apps Store page. You can also go to the Apps menu in QuickBooks Online, then enter a keyword in the search field.
After that, make sure the format and accounting method are added correctly before importing them to QuickBooks Online.
Additionally, I've added this article that'll help you review the transactions to add them to the correct accounts: Add and Match Downloaded Bank Data.
Please keep us posted if you need additional assistance uploading your data. We want to ensure you this gets resolved. Stay safe!
Thank you so much for answering so quickly. I managed to exclude them but not delete them now. i really appreciate your answer. I did it one item at a time, twice! But I guess I am learning. I really appreciate you getting back to me. I felt less alone with it! All the best, Jane
Thank you so much. I know the definitions for double-entry book keeping but the bank labels income and expense differently to double-entry booking keeping. Income is a credit to my account. Debit is an expense. So when I import them, what should these entries be on the spreadsheet?
Whereas income is an increase to my business income so that would be a debit, while expenditure is credits. So I don't know how to label my spreadsheet. I got it right when I did it intuitively but now I am not sure as this doesn't make sense to me any more. I studied accounting once and I struggled to grasp it then but once got my head round it.
I will study your article and have a think when I have calmed down.
Thank you so much for replying. I very much appreciate it. I am finding it so stressful but the bigger issue is microsoft won't convert the xls file to cvs but I think they may be upgrading.
All the best and many thanks,
Jane
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.