In either case we can safely import these transactions while maintaining the Quickbooks invoice numbering sequence.Īs you can see, we only touched on a few of these features. There could be a number of reasons for this, such as order cancellations or orders not shipped.
In this example there missing Order numbers in the data file. This feature is great when you are importing orders that may not be in sequence or do not match your Quickbooks invoice numbering system. When you click on the Options button you will see the feature to Auto-Assign Invoice numbers. Let us have a look at some of the Options in Transaction Pro for Quickbooks Online. When the data is imported it will post the other side of the transaction to the MasterCard account. In this example below, we have taken credit card statement data and coded a GL account to each of the lines. It can also be used for importing a credit card statement where every expense line is a separate transaction. You can post out of balance entries to a specific account so that your import will not stop because it is out of balance. You can map up to 15-line items that are positioned in separate columns.Īnother extremely popular feature is the Journal Offset Account. Once this feature is enabled, the mapping screen in transaction pro will give you additional fields to which you can map. Some Expense management systems will send data to a csv file putting each transaction line as a separate column.
Most data files will show a different transaction line as a separate row versus a separate file. If you enable the columns as rows for bills feature it will allow you to map your Excel worksheet vertically versus horizontally. If you are using Quickbooks Desktop, you have probably noticed that there is an options feature as shown below. Here are a few of my favorite features that are available in Transaction Pro for Quickbooks Desktop and Quickbooks Online. There are so many Options and Features to enhance your imports that offer flexibility in many different source import file types.
0 kommentar(er)
