cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
phils673
Level 2

Client Accounts

All my clients are paper based small businesses. With MTD looming, I want to transfer them to QuickBooks. 

1. Do I have to buy a subscription for each client even though they will continue to give me a box of paper files.

2. I do most of my analysis work on excel. Can I simply upload trial balance to QuickBooks for each client and if so, how?

3. As my clients are paper based, I don't have the option of linking bank accounts electronically. Can I manually enter the transactions, and if so how?

4. For my bigger clients, MTD is obviously going to be an issue both for VAT and in later years corporation tax. Is QuickBooks set up to meet the requirements of MTD?

 

A lot of questions I know and probably covered by the online training materials, but as a fledgling business myself and being disabled, I just haven't had the time to work through it.

Solved
Best answer September 17, 2018

Accepted Solutions
JamesC
QuickBooks Team

Client Accounts

Hi Phils673,

 

Welcome to the UK Community Page for QuickBooks Online.

 

1 - Yes, however if you speak to our sales team one of our Account Managers will be able to arrange wholesale discounts for you. Speak to 0800 014 2654.

2 - You can use Journal Entries to record changes to your Balance Sheet if required, you don't have an option to upload a trial balance, but you can upload a Balance Sheet list of Accounts, with the Opening Balances of those accounts, you can then adjust the balances using Journal Entries on QBO. The same number above ^ will be able to advise of any available training courses that you can attend local to yourself.

3 -  You can manually upload a list of transactions from Excel, in the form of a .CSV spreadsheet, and then use our Banking feature to upload the transactions. Alternatively, you can enter any transaction manually using our "plus" icon to access all the different types of transactions available to you.

4 - QuickBooks will be ready for MTD for VAT Submissions April 2019, and we are looking into including Coorporation tax, but i don't have a timescale for the Corp Tax to be included.

 

Thanks,

View solution in original post

19 REPLIES 19
JamesC
QuickBooks Team

Client Accounts

Hi Phils673,

 

Welcome to the UK Community Page for QuickBooks Online.

 

1 - Yes, however if you speak to our sales team one of our Account Managers will be able to arrange wholesale discounts for you. Speak to 0800 014 2654.

2 - You can use Journal Entries to record changes to your Balance Sheet if required, you don't have an option to upload a trial balance, but you can upload a Balance Sheet list of Accounts, with the Opening Balances of those accounts, you can then adjust the balances using Journal Entries on QBO. The same number above ^ will be able to advise of any available training courses that you can attend local to yourself.

3 -  You can manually upload a list of transactions from Excel, in the form of a .CSV spreadsheet, and then use our Banking feature to upload the transactions. Alternatively, you can enter any transaction manually using our "plus" icon to access all the different types of transactions available to you.

4 - QuickBooks will be ready for MTD for VAT Submissions April 2019, and we are looking into including Coorporation tax, but i don't have a timescale for the Corp Tax to be included.

 

Thanks,

phils673
Level 2

Client Accounts

Thanks James, can I quickly ask a couple more questions?

 

1. Is it possible to buy multiple of the 10 for £10 offer ie, 30 for £30?

2. Do you know what the price will revert to once the offer expires, as presumably QuickBooks won't be charging £1 per client per month for ever?

3. How do I set up a client that operates as a partnership, as there doesn't seem to be an option for this?

Thanks

 

Anonymous
Not applicable

Client Accounts

Hi phils673,

 

Thank you for getting back in touch. 

 

I would recommend to give the number my colleague provided a call as prices and offers are different for accountants and I want to make sure you are given the correct information. 

 

Thanks, Carly. :)  

phils673
Level 2

Client Accounts

thanks again. Last question, promise (for now at least)

How does one manually enter bank transactions, there appears only to be an option to either link to an account or upload a .csv file for which no template is given?

As my clients give me physical paper statements it would be useful ti be able to manually input.

AlcaeusF
Moderator

Client Accounts

Welcome to the QuickBooks Community, phils673.

 

I can show you how to enter bank transactions manually from bank statements.

 

Here's how:

 

1. Click the Gear icon.

2. Select Chart of Accounts.

3. Choose your account and click View register.

4. Click the drop-down arrow below the Date column (see screenshot below).

 

If you need more assistance concerning your QuickBooks Online, please let me know by leaving a comment below. I'll be sure to get back to you.

phils673
Level 2

Client Accounts

thanks, I'll give that a try. I'm just a little concerned that the chart of accounts doesn't appear to include a bank account line

AlcaeusF
Moderator

Client Accounts

Greetings, phils673.

 

I appreciate your prompt response concerning the paper statements.

 

To enter transactions directly into the bank register, you'll need to make sure your bank is listed under the Chart of Accounts. For more information about how you can add the transactions, please follow the outlined steps in this article:

 

How do I add transactions to my bank register?.

 

If your bank isn't listed under the Chart of Accounts, you can create it by following these steps:

 

1. Click the Gear icon.

2. Select Chart of Accounts.

3. Click New in the upper-right corner.

4. Enter necessary information.

5. Click Save and Close.

 

Please don't hesitate to reach out if you have any questions concerning QuickBooks Online. I'll be around to help.

EmilyMockett
Level 7

Client Accounts

Hi there,

 

1. Do I have to buy a subscription for each client even though they will continue to give me a box of paper files.

When you are an accountant you should have an accountant profile. This can be set up directly with QuickBooks Online.

 

2. I do most of my analysis work on excel. Can I simply upload trial balance to QuickBooks for each client and if so, how?

You will upload your trial balance directly to QuickBooks Online. This also works the other way where you can export the trial balance out of QuickBooks into excel.

 

3. As my clients are paper based, I don't have the option of linking bank accounts electronically. Can I manually enter the transactions, and if so how?

Ideally it is best to get bank accounts linked up as this will speed up the process. However you can manually upload excel files into QuickBooks in bulk which may speed up the manual process a little. This video may help: 

 

4. For my bigger clients, MTD is obviously going to be an issue both for VAT and in later years corporation tax. Is QuickBooks set up to meet the requirements of MTD?

Yes QuickBooks is set up for HMRC VAT requirements.

 

As QuickBooks Firm of the Future for this year, we would be happy to help with nay questions you may have. Please get in touch with me via private mail if you need any assistance with anything. 

Emily

JamesC
QuickBooks Team

Client Accounts

Hey @phils673

 

If your customers are sending you a list of transactions, you can create your own csv in excel. The headings you'll need are as follows:

1 - Date

2 - Description (Payee included)

3 - Amount in

4 - Amount out

 

If the transaction is money in, leave money out blank; and visa versa.

 

You can upload this into the Banking screen, and link it to the account to which you're uploading the treansactions for. This will give you a really easy to use system for adding transactions in through our banking screen. You can even create banking Rules for repeat transactions and ones which occur more often that have the same description as past transactions.

 

Thanks,

phils673
Level 2

Client Accounts

Thanks very much - I'll give that a go

phils673
Level 2

Client Accounts

Thanks Emily, much appreciate

bobfox57
Level 1

Client Accounts

Recent invoice.

bobfox57
Level 1

Client Accounts

Is someone THERE !

bobfox57
Level 1

Client Accounts

Recent Invoice is WRONG

EmmaM
QuickBooks Team

Client Accounts

Hi Bobfox57

 

In regards to the invoice what is incorrect on it?

 

Kind regards

Emma

abell80110ck5
Level 2

Client Accounts

Yep that's the problemo with onslime accounting/cloud-based products - they are costly for small clients who only have a few transactions.

 

if you r not bothered by cloud, use VT, it's site-based licence really £120 pa, and it's got mtd of course. And you can churn out all your accounts through their templates. what's not to like?!

Smiley Wink

Nygree
Level 1

Client Accounts

I set up a clients account. However they never received the to email to setup m.  service .How do i get our systems to link in .

Mark_R
Moderator

Client Accounts

Hi there, @Nygree.

 

You'll want to let your client check their spam folder and check the email from there. Also, you can resend an email invitation if you're client hasn't received the email. Let me guide you how.

 

  1. From the Navigation menu, select Clients.
  2. Choose Add client.
  3. Select whether the client is a Business or Individual.
  4. Fill in the Business name and Email field. Make sure that the email is correct.
  5. Choose the QuickBooks subscription.
  6. Select Compare, then choose your product choice.
  7. Once the subscription is created, an email sent to your client.
  8. Under Team Access, select which team members in your firm can access the client. 
  9. Click Save.

I've got you an article for more details: How to Create a Client in QuickBooks Online Accountant.

 

But if you're trying to link the Merchant Service account to your client's QuickBooks Online, you can check out this article for the detailed information: Connect your Payments Account to QuickBooks Online.

 

Please know that connecting the Merchant Service account is only applicable for one account.

 

You might also want to check this article to learn how to manage your client list.

 

Please don't hesitate to leave a reply below if you have additional questions. We're always here to help.

Nygree
Level 1

Client Accounts

Thanks @Mark_R 

 

I have done that twice still no luck I think I am going to remove their account and input every everything again.

 

Need to get in touch?

Contact us