Go to Settings and select Import desktop data. If you need detailed instructions, here's a deeper dive into exporting data from QuickBooks Desktop. In QuickBooks Desktop, go to: File > Utilities > Import > Web Connect Files. Most businesses and their accounting firms have no idea that they can import anything into QuickBooks with a little help from a. Go to Settings and select Import desktop data. If you are looking to import Statement data to an account that is already connected to a Bank Feed, you will need to disconnect the Bank Feed first. Next, import the data to QuickBooks Desktop as follows:
Generally you can just cast your eyes over the above fields before clicking Download, but do make sure the Account Number is captured and, if not, at least that it's unique. You will have to map the worksheet columns to the appropriate. See below if you receive an error that QuickBooks cannot verify the institution details. Rather than copying and pasting large amounts of data from a Microsoft Excel worksheet into QuickBooks, use QuickBooks' Import option. Using the Wells Fargo default will make no difference in getting the data into QuickBooks Desktop except that you will have a Wells Fargo logo associated with it. If you know the INTU.BID of your own bank you can enter it here. In this case we've used a common Bank ID for Wells Fargo Bank (03000). INTU.BID: We mentioned earlier that we mimic a Bank Feed in order to make this Bank Data import and as such we need to include a recognised Intuit Bank ID for it to be accepted by QuickBooks Desktop.
If not you should enter the unique Account Number for this account as QuickBooks Desktop will recognise it for future imports (if you decided to use a fake generic number on two separate accounts this will cause you issues as the data may merge into the wrong account automatically - so make sure this number is unique per Bank Account even if you don't use the true number).Īccount Type: Choose the most appropriate Account Type from the drop-down.Ĭurrency: Currently USD is the only supported currency.īank ID: This is the bank's routing number - if you have it you should enter it but the default zeros '000000000' is fine. Account Number: So long as the Account Number is visible, AutoEntry will capture it and it will appear by default here.
0 kommentar(er)
