Skip to main content
March 28, 2023
Question

Retrieval of the account income and expenses allocation

  • March 28, 2023
  • 1 reply
  • 0 views

Hi all,

 
After a weird software glitch the system has mixed up which account the transactions are from and allocated transactions from one account to the other as well as doubled the transactions across the board when trying to reconnect the bank account. This, with all the rules being also applied to certain transactions, proved to be an impossible task to resolve by myself. Even though talking to three different customer service providers we were unable to restore my account to the original state. Therefore all the work that I have put in using the app in the last year has been lost with all the allocations of expenses and earnings. I'm extremely disappointed that since I have been a customer for more than two years this wasn't possible to resolve and I am now left to start my 22-23 tax return from scratch. I've managed to unlink both accounts and add them both in completely fresh. Is there a way of retrieving the information about the allocations whether the transaction was an expense/income or personal and with all the rules that were applied?
 
Best wishes,
Jernej

    1 reply

    March 28, 2023

    I can imagine the hurdle you've been through to resolve this problem, jalbre. I'll make it up to you by providing details on how you can fix the banking transaction issue you're having in QuickBooks Self-Employed (QBSE).

     

    Currently, there is no direct way to retrieve all of the income and expense transactions allocated to your accounts in QBSE. What you can do is import your bank transactions manually and categorise them one by one.

     

    Let's start by requesting a CSV file from your bank, or you can download transactions through a CSV file from your bank's website. Once you have the CSV file handy, you can follow these steps to import it into QBSE:

     

    1. Open QBSE in a web browser. Go to Settings ⚙.
    2. Select Imports transactions. Then, tap Import older transactions for the account to which you want to add transactions.
    3. Click Browse and find the file you downloaded from your bank. Then, choose the file and click Open to start the import.
    4. Review the column headers and data. Make sure the CSV's date, Description, and Amount columns match the columns and order in QuickBooks.
    5. Select Continue to complete the import.

     

    After that, you can categorise your transactions one at a time. Here's an article for your reference: Categorise transactions in QuickBooks Self-Employed.

     

    Otherwise, I recommend seeking assistance from your accountant for more about expert ways and other methods of dealing with this situation.

     

    Please don't hesitate to reply anytime if you still have questions or clarifications about managing transactions in QBSE. I'm more than happy to assist you. Stay safe!