The Book-keepers Forum (BKF)

Post Info TOPIC: Inputting a CSV or Excel spread sheet into QBO - Help needed please


Expert

Status: Offline
Posts: 1991
Date:
Inputting a CSV or Excel spread sheet into QBO - Help needed please


Hi Everyone,

 

Its been along time since I asked a question on here but I am in need of a little help please.  I am not very techy so excuse my lack of knowledge!

I have QBO for a new client and they keep a spread sheet of all of their sales which is great.  Due to the long list per quarter and the nature of their sales ledger I was wondering if I could perhaps save as a CSV or just an ordingary spread sheet and then up load it into QBO??  The only problem is some of the sales are Vatable and some are exempt.  This split is all on the spread sheet, although some invoices will have VAT and exempt vat on it (MOT's in a garage).  So is there an easy way to do this or at least export the majority in there?  I really don't mind if I have to manually put in the sales invoices that have both servicing and MOT's on it as I don't think that would be too big a task to do.

Any help with this would be appreciated as time is running out as it is this VAT quarter that has to be done.

Thanks



__________________

Amanda



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Hi Amanda
Long time no see.

I think you might be our resident QB person so not sure this will help, as I don't use QBO. But just a couple of thoughts from other software. Does it have an 'import' function? Or allow for batch invoices?

If the former, then the software should present you with an import format/template. If there isn't the latter, then best guess would be to try to import just one line of data.You can then interrogate this online to see that it shows up how and when you want it to/correct income codes etc. Out of interest can you do manual backups on this software? Always handy pre a batch import.

Other option, dare I say it, given they are not using QBO for their invoicing (presume it's some form of garage management software.....which one out of interest? Plusis it any good?), do they really need that software? Maybe consider, if the above doesn't work, dropping the data into a package that easily takes the imports such as VT? Or Sage?

One place to consider looking for info re QBO, assuming you've exhausted their help desk, is YouTube videos. Might be something helpful there.

Only other thing, vat on MOTs is outside the scope if they are supplying themselves, rather than Exempt. Subtle difference on the surface, but none of those partial exemption shenanigans (for anyone else reading this).

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Expert

Status: Offline
Posts: 1991
Date:

Hi Joanne,

Thanks for the information, I did actually find an import button last night so I might as you suggest do one line and see if it imports okay, if it does then that will be brilliant! They have a manual invoice system and then they put it on a spread sheet just to keep tabs on who has paid and who owes, eventually we will be getting the invoicing done on QBO, but one step at a time at the moment.

I've never imported anything into QBO, I have done it in Xero once a long time ago and to be honest I thought Xero was cumberson, so I am hoping that QBO will be a lot better. I know they are improving the online softwares all the time so I am keeping my fingers crossed! I don't particulary want to go down the route of an app or a 3rd party piece of software to do the job.

You tube videos is something I am going to look at today, there is bound to be something on there, so thanks for the suggestion.

Many thanks.

__________________

Amanda



Master Book-keeper

Status: Offline
Posts: 3904
Date:

Hi Amanda 

Have a look at this, it's not for what you want to do but should give you a rough idea of how to import. It's only two mins long and doesn't sound too complicated.

https://www.youtube.com/watch?v=vciM8A_6Gwo



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Expert

Status: Offline
Posts: 1991
Date:

Hi John,

Thanks for this, I have had a look at it and it is similar to what I managed to do this afternoon. I have managed to import all the customer names etc, I am not a techy person so I am quite pleased with myself for getting this far! Now I need to import all the sales, I think I have nearly done it but it needs tweaking abit, the important thing is it has to be mapped the same way apparently.

I will save a heap of time!

Many thanks,


__________________

Amanda



Master Book-keeper

Status: Offline
Posts: 3904
Date:

Ah good, hope you manage to get the rest sorted.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Senior Member

Status: Offline
Posts: 476
Date:

click on sales, invoices then in the top right corner on the button that says new invoice if you clikc on the arrow you can select import invoices. you can download an example csv file to format your file.

__________________


Expert

Status: Offline
Posts: 1991
Date:

Hi Everyone,

Thanks for your replies, I have managed to map it and do 3 months worth of sales from the spread sheet and import it onto QBO! There are a lot of sales per month so I was glad I could do this otherwise I would still be there inputting them manually!

Many thanks,

__________________

Amanda

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About