#Transaction pro update#
#Transaction pro pro#
#Transaction pro code#

#Transaction pro code#

So, we would add a formula to our import to automatically code which account each type of deposit should be imported into. Sometimes payments would be made by Paypal, sometimes by check, etc. The one nuance here was that our client would receive payment in different formats.

#Transaction pro pro#

The file is pretty clean to just copy and paste into an import template for Transaction Pro Importer.

Note (This would list the PayPal transaction ID if PayPal was used).

Number (which is the actual invoice number).

Payment For (which would be filled with “Invoice”).

Once we imported the invoices, we would also create an upload file for the payments.This is a separate export file from Freshbooks. We would have definitely done more research on our process if tax were a bigger issue here.

#Transaction pro update#

But, only a few transactions a month were actually taxable, so we would go back into QuickBooks Online after the import to update the invoices manually. This client sold and shipped to several different tax locations, so it wasn’t a clean import. The biggest hurdle we had was getting the tax amounts imported. We would also do the same for the Client Name looking for potential duplicates with names that were entered just a bit differently. Therefore, we match the Items from Freshbooks to the current Item list in QuickBooks Online to see any new list items.

When doing these types of imports, it is always important to make sure you aren’t adding a bunch of items to your QuickBooks Online database. With some sophisticated Excel formulas, we were able to add the class and salesperson fields (actually using Locations for this in QuickBooks Online). We were even able to work with some of our client’s current reporting to add some fields into our upload spreadsheet. Using Transaction Pro Importer, we are able to match these fields up to the fields that are available in QuickBooks Online. Here are the fields that Freshbooks provides: We started with exporting the invoices for the month. Importing Freshbooks Invoicesįreshbooks has several good reporting options to help you get the information you need to import into QuickBooks Online. We tested out a few automation tools, like Zapier, but it didn’t quite fit the situation we were going after, so we created a customized process for our client and utilized Transaction Pro Importer to get the invoices into QuickBooks Online each month. Our client wanted us to be able to get all the detail from the invoices into QuickBooks Online in an efficient manner. We recently had a client that came to us with this issue. If you are getting a file parse error, please ensure you have the same file structure.There are several tools out there to help with importing Freshbooks invoices into QuickBooks Online, but not all of them do exactly what you want them to do. This will allow you to go back to your original data if you decide to start the import over with different parameters.Īttached you may find a sample OFX file. Please note, that the app automatically creates a backup file before importing a CSV file.

For example, if the CSV file has a category named 'Food', you can match it to an existing category 'Groceries', or create a new one. If necessary, the app will ask whether the accounts and categories in the file match the ones in the app. Please, keep in mind that it is not obligatory to assign value for each column, tap/click “Ignore column' to skip the column you don’t want to import. In case you select “Account' and “Account (to)', a transaction type will be automatically defined as “Money Transfer'. Amount received: the amount received by the account you are transferring money to. Amount: the amount you transfer from the first account. Account (to): the account you are transferring money to. Account: the account you are transferring money from.

Money Pro allows to import “Money Transfer' transactions, therefore the app has “Account' and “Account (to)', “Amount' and “Amount received' data types. Positive amounts will be identified as Income transactions while negative - as Expenses. The transaction type (Income/Expense) will be defined automatically based on the positive or negative value of a transaction. Use the button “Next' in the upper right corner to go to the next column.

Start by assigning the data type to each column: “Category', “Amount', “Amount received', “Date', “Account', “Account (to)', “Description', “Agent', “Currency', “Check #', “Class', “Time'. When importing a CSV file you have to specify the type of information for each column individually, if the app hasn’t determined it automatically. From now on, Money Pro will assign categories based on your choice. Tap/click the question mark icon next to the transaction and choose the right category. The apps are on the Files view.ĭuring import, you will be offered to assign categories to transactions. Follow this link to insert the file into the app.