cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Highlighted
Level 1

Starling Bank - Pots

Hi Everyone,

 

When the Starling bank feed's went live, i connected this up with my client, my client used Pots but there was no way to link the pots so i set up a bank account manually in the COA and put opening balances for these pots, which from this it all seemed to be great.

 

Now my client has just called up whilst reconciling, within the reconciliation period there was some money moved from the main account to one of the pots, Quickbooks have pulled this up on the bank feed which we transferred to the Pot, but it does not appear on the bank statement. 

 

So the only way we can reconcile is by unticking the movement of money, I have no idea how this will work as i'm guessing Starling works in the way of its all one account but just split up, which doesnt really help when you cant connect the pots, so the movement of money cant be tracked in QBO.

 

any support or guidance would be great, i've tried speaking to Starling direct with no luck.

 

thanks,

Ryan

 

3 REPLIES 3
Highlighted
QuickBooks Team

Starling Bank - Pots

Hello Ebbage, 

 

Looks like starling just have the one account that gets split into the different pots but all come under the same one. 

 

I would recommend that on the banking page if you just exclude the transaction then it will not appear on the reconcile so that you are not left with a transaction that follows you each time. that you are unable to reconcile with. 

Highlighted
Level 1

Starling Bank - Pots

Hi Ashleigh,

 

It is just confusing to the client as this is a transaction which appears as they do their own bookkeeping, so if we exclude them then i guess we will just need to know an update of any of the balances as the end of year. 

 

I'm just conscious of if the transfer amount within the starling accounts increases alot that you will have alot of transfers to exclude.. there surely must be a more convenient way! 

 

Thanks,

Ryan

Highlighted
Moderator

Starling Bank - Pots

Thanks for getting back, Ebbage.

 

Your bank statement and QuickBooks balance should match when reconciling. Transactions that are not in your statement but are showing in the Banking page must be excluded.

 

Here's to exclude:

 

  1. On the left panel, click Banking.
  2. Choose an account.
  3. Go to the For Review tab.
  4. Put a check mark on the transactions you want to exclude.
  5. Click the drop-down arrow next to Batch actions and choose Exclude Selected.
    QBO exclude.PNG

You may find this article handy to learn more about the process of excluding downloaded transactions in QBO.

 

However, the best source of information for a question like this will always be an accountant for best accounting practices.

 

Let me know if you have any follow-ups or other questions. I'm always here to help. Wishing you a good one.