Of course, my practice has changed in many ways over the last seven years, but when I stop to compare the amount of work I did 7 years ago to the amount of work I do now, I feel just as overwhelmed. Specify the date range for which to export When I look at the mountains of paperwork from pending tax returns on my desk that I need to prepare, I can’t help but think about the last 7 years of my practice. In the File Location field, enter or browse to the location where you save the clients QuickBooks data, and then select the appropriate QBW file in which to store the export data. In the Type of file to create field, select Export directly to QuickBooks (.QBW file).In the spur of the moment when importing thousands of transactions in 1 hour, there is a chance I may have misclassified some expenses. In some cases, I charge the exact same fee because clients are willing to pay for the value of your work instead of the time spent, but that’s a topic for another article.Second, in combination with Batch Enter, I can use Add/Edit Multiple Vendors to quickly add a large list of vendors/payees to speed up that process even more.Third, Reclassify Transactions is another incredible tool. What used to be a 2-day job turned into a 2-hour job. Add/Edit Multiple Names (available in Pro/Premier/Mac as well)First, with Batch Enter Transactions, I can take 12 months of bank transaction data (assuming the data was available through the bank) with hundreds or thousands of transactions, clean them up in Excel and then proceed to copy/paste into QuickBooks.In some cases, and if the data is easy to clean in Excel, I will import the data into QuickBooks using Batch Enter, as shown on this video. Transaction Pro Importer by Baystate ConsultingHere’s how I’m using these tools, sometimes in tandem, based on these scenarios:Scenario 1: My client does not give me a QuickBooks file with his own bookkeeping instead, he gives me all the printed paper statements for banks and credit cards because there is no other digital version of the client’s bank transactions.ScanWriter Excel Edition allows me to take all the transaction data from the bank statements I scan and converts them into a debit/credit format for Excel. By adding third-party tools and apps, the software truly rocks with the following features that complement my larger data entry bookkeeping jobs:
How Send Quickbooks File To Accountant How To Do ThatHere’s a video explaining how to do that.Scenario 3: My client gives me his QuickBooks File, and only part of that information is useful. QBO format and download it via Bank Feeds. I use 2qbo Convert Pro, by itself, to convert the data to. QBO (Web Connect File) using 2qbo Convert Pro, in order to import them using Bank Feeds.Scenario 2: My client gives me all of her bank statements in their native PDF format as downloaded from the bank, or in a CSV (Excel) file with all the bank transactions. Does emulator work on macThe only way for me to import these detail-level transactions is with Transaction Pro Importer (TPI). For the rest of the data, I would use Scenario 1 or 2, depending on the circumstance.Scenario 4: My client provides a list of transactions with multiple lines, such as Invoices with multiple line items, in CSV or Excel format, which is very common for clients that have eCommerce. I use Data Transfer Utility to copy just the checks from my client’s QuickBooks file into my own, clean file. That’s the mark of true success. Instead, I want all of my clients to feel as if I’m a true partner to their businesses and needs.
0 Comments
Leave a Reply. |
AuthorAmber ArchivesCategories |