 QuickBooks Desktop 2023. Convert CSV file to QBO data file so we can upload it into the QuickBooks Desktop Bank feeds. Let's do it. We're into it. QuickBooks Desktop 2023. Support Accounting Instruction by clicking the link below giving you a free month membership to all of the content on our website broken out by category further broken out by course each course then organized in a logical reasonable fashion making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems PDF files and more like QuickBooks backup files when applicable. So once again click the link below for a free month membership to our website and all the content on it. Here we are in QuickBooks Desktop Bank feed practice file. We started up in a prior presentation going through the setup process we do every time view drop down. We got the hide icon bar open windows list checked off open windows open on the left reports drop down company financial P&L profit loss income statement change the range 010122 to 123122 customize and the report fonts numbers need to change to 14 that's where they need to be they have to be there that they need to be there and then reports drop down again company financial this time balance sheet standards customize and it for the change of the range 010122 to 123122 and then fonts and numbers also changing to that 14 spot okay yes and okay banking drop down bank feeds we're looking bank feed center people which would only be there if we set up bank feeds which we did in the prior presentation so we're now looking at the two items we uploaded to the bank feeds the checking account and the credit cards now we're thinking about the PayPal we noted last time that we had a few kind of things that we might do for these intermediary trans platforms including possibly just waiting till the deposits clear the bank and then recording them that way and our normal checking account if we're just using them as an intermediary platform although we do lose some data that way or we can try to use an app to help us to integrate the systems and the platforms or we can try to make another bank feed for the PayPal which we cannot do directly at this point in time a direct connect with the desktop version I don't believe without possibly an app to help with that process so we can download the data and enter that into the system we could do that manually by entering into the register or we could try to upload the bank feed file into the system which is what we're going to do here now so we if I if I think about the downloading of the data file we downloaded as a CSV file because PayPal currently doesn't have the option which hopefully they'll change at some point in time of downloading a QBO data file which is the file necessary to make that automatic kind of upload into the desktop version so then the question is well once I have this file the CSV file which usually is opened up we can open it up just like as an Excel file without any of the formatting for it just remember it's not an Excel file if you do any formatting to it it's going to disappear we cleaned it all up so we just have basically date and then the information here and then the increases and decreases in one column so that we can now just use this to transfer it into a CSV file onto a QBO file and that's what we'll do this time note if you only have this many transactions you could just try to upload it directly into the the QuickBooks system manually you could just enter it into the register and that wouldn't take too much time but we'll try to use the conversion software so we're going to be using this software I'm not promoting them it's just a software that's that's advertising that it can do the conversion and you can look at the payment structure on it here if you wanted to check it out on your own I think it allows you to convert 10 items for free so if you had a lot of of uploads you'd have to break them out possibly into multiples of 10 if you didn't want to pay for it which we'll test out at this point in time so let's say on ours for example we've got you know 15 transactions so let's save two of these so I'm going to go up and I'm going to say file save as and I'll try to make another CVS file which will be PayPal 2 so I'm going to say okay and so now if I look at my data I'm going to close this up I've got PayPal 1 and PayPal 2 so then I'm going to open both of these up so I'm going to open up PayPal 1 I kind of adjusted the order of them before so you could try try to adjust like if I select these items and I go to the data and I want to put my filters in here I could sort and I should be sorted by date which will typically be sorted by default by date and then I'm going to open up the other one too I'm going to say PayPal 2 and notice that those those sorting fields will go away because it's a CSV file when I save it I'm going to say data sort filters by date and then I'd like to compare the two files so I'm going to put these side by side and so then we'll say okay so now let's bring this one down to like here and then delete everything underneath it right click and delete and then this one will start at the 24 and will delete everything above it so we've got two files that are less than 10 transactions that I can convert each of them hopefully I didn't delete anything too important so I'm going to say save hit save it and then I'll say save that one so there we have it I'm going to save replace CSV 2 okay so now I'm going to open up my converter software over here and I'm going to browse for my file so I'm going to say that this is on the desktop and we've got PayPal 1 so it pulls over the transactions so that looks good I want to convert it to a QBO type of file so that looks good let's go ahead and convert it and see what happens here so we're going to say all right select and then we'll put this on the desktop PayPal 1 boom conversion process so here we have it it might try to open up your your QuickBooks automatically and upload it but we'll do that later so now we've got our file for that one I'm going to do the same thing for the second one now so I'm just going to say all right let's do the second one that worked good so I'm going to say let's try the CSV 2 on the desktop or the PayPal PayPal 2 payout pal it's going to go to a QBO so we're going to say okay everything looks like it's working the way it's supposed to so let's do that and then it converts that one again it might try to open QuickBooks and open it up automatically but we'll not gonna I'm not going to do that here I'm not going to do that yet we'll do that next time so now we've got these two files that are the QB0 files for PayPal 1 and PayPal 2 and I can use those to upload so that it looks like that software is working pretty good it's kind of a pain that you got to you know do this conversion thing I would hope that PayPal would would make it so you can have a QBO file at some point in the future they have other file types I'm not sure why they wouldn't use this one it's quite common or and or that QuickBooks would allow the link to happen and or allow us to upload the CSV file the CVS file or whatever but you can use a conversion or an application possibly to help out with that if you paid for this then you can have a whole bunch of transactions that you can download and upload in a similar fashion so next time we'll add these into QuickBooks as we've done with the prior items here we'll end up with another PayPal account that we'll have to set up we'll add the date the detail into the system and we'll see the difference between you know just waiting till something clears the bank and as adding it as income to adding the PayPal income as income and then matching out the transfers from PayPal to the checking account