![how far back can quickbooks import credit card transactions how far back can quickbooks import credit card transactions](https://propersoftcontent.b-cdn.net/howto/import-csv-or-excel-files-as-qbo-into-quickbooks/import-csv-or-excel-files-as-qbo-into-quickbooks7.png)
As you record your bill payments and your customers’ invoice payments, QuickBooks updates your bank balance. You’ll have an accurate view of which invoices and bills are paid in full, which are partially paid, and which aren’t paid at all. Paying attention to these two guidelines will pay off big for you later on. That way QuickBooks knows which bills you’ve paid and what invoices your customers have paid. Likewise, if a customer has sent you their payment, then QuickBooks needs to know what invoice the payment is for. If you tell QuickBooks you’ve made a payment, QuickBooks needs to know what bill that payment is for. You must enter bills and invoices first before you enter payments. So the only bank transactions you’ll have to enter in your bank account are those that are still missing after you finish entering transactions for accounts payable, accounts receivable, and payroll. You want to do this because your Accounts Payable and Accounts Receivable accounts affect your QuickBooks bank accounts (but not the actual account at your bank).
![how far back can quickbooks import credit card transactions how far back can quickbooks import credit card transactions](https://i.ytimg.com/vi/L_PFKQbRPRU/maxresdefault.jpg)
This may seem counterintuitive, but stay with me here. There are two important guidelines to keep in mind as you enter historical transactions:Įnter transactions in your bank accounts last. Remember, though, that your account balances may be off until you’ve entered all the transactions back to your start date. Try breaking them into digestible chunks, like a week or month’s worth at a time. Then catch up with historical transactions when you can. Go ahead and start entering current transactions as they occur so you don’t get behind. You don’t have to enter all your past transactions before you start using QuickBooks. So this is important to know: You can enter historical transactions at any time. You probably have current transactions happening right now that you need to record, as well as get your historical data into QuickBooks. Just because you starting to use QuickBooks doesn’t mean your business has stopped running. Accurate sales tax reports for any period after your start dateĭo I wait to enter current transactions until I get the historical data in?.Accurate year-to-date profit and loss statements.Up-to-date records of what customers owe you and what you owe vendors.The ability to reconcile your bank and credit card statements with your QuickBooks bank and credit card accounts.Accurate balances in your bank accounts and all other accounts.After you enter your transactions from your start date up to today, you’ll have: Why enter my historical transactions?Įntering historical transactions gives you an accurate look at how your company is doing in the present and over time. If you’re in doubt about what your start data should be, check with your accountant. You’re just starting your QuickBooks file at a moment in time. So you should enter all your past transactions back to January 1 of this year.Ī little confused? Don’t be. You set the company file’s start date to January 1, even though you’ve been in business for three years already.
![how far back can quickbooks import credit card transactions how far back can quickbooks import credit card transactions](https://fitsmallbusiness.com/wp-content/uploads/2020/09/Screenshot_Banking_Center_in_QuickBooks_Online.jpg)
For example, let’s say your new year’s resolution was to move your business finances from spreadsheets to QuickBooks. Your business may have existed for longer than that start date, but that’s OK. If you entered a start date in the past, you’ll need to enter all historical transactions from that start date through today. When you created your company file, you entered a start date for your company. But even if you don’t have all the historical data in your company file, you can (and should) still keep going with entering new transactions along the way. It may take some time to get everything in there. And as with most moves, you probably won’t do it all in one fell swoop.
![how far back can quickbooks import credit card transactions how far back can quickbooks import credit card transactions](https://fitsmallbusiness.com/wp-content/uploads/2020/09/Screenshot_Selecting_the_Right_Date_Range-1.jpg)
It’s moving day! Only instead of moving offices, you’re moving your data into QuickBooks. But for now, here’s a bird’s eye view of what you need to do. Over the next few days, l’ll post more articles with details of what I talk about here.
HOW FAR BACK CAN QUICKBOOKS IMPORT CREDIT CARD TRANSACTIONS HOW TO
Part 1: Overview | Part 2: Vendor transactions | Part 3: Customer transactionsĪuthor’s Note: This is the first-a brief overview - in a series of articles explaining how to get your business history into QuickBooks.