Skip to main content
Ebbage
Ebbage
February 24, 2020
Solved

Starling Bank - Pots

  • February 24, 2020
  • 1 reply
  • 0 views

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

 

Best answer by AlcaeusF

Hi,

 

I am facing the same issue and was hoping to fund the answer here.

 

I am wondering if you exclude transaction of moving money from the main account to pots/space from your bank feed, QBO thinks this money was spent/disappear, doesn't it?


Hi there, @fusé-Osaka.

 

Welcome to the Community. I'm here to provide some clarification about how the process works in QuickBooks Online.

 

Yes, you're right. When you exclude a transaction from your bank feeds, it will disappear from the For Review tab and will not be added to QuickBooks.

 

Once you set up the pots as sub-accounts, all the transactions that you enter will roll up and reflect in the main account. If the pots/spaces aren't part of the reconciliation, I recommend creating it as a separate parent account in QuickBooks.

 

By doing so, you'll still be able to track transfers. However, I recommend seeking expert advice from an accountant to ensure your books will be accurate and error-free.

 

For additional reference, you can use the following articles to learn more about setting up sub-accounts, as well as how to move funds between accounts in QuickBooks:

 

Fill me in if you have additional questions about handling pots in QBO. I'm always here to help. Take care always.

1 reply

A
Ashleigh1
February 24, 2020

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. 

Ebbage
EbbageAuthor
February 24, 2020

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

C
Charies_M
February 24, 2020

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.

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.

Terms & ConditionsAccessibility statement