Authorize.net - import / download payments

Thanks for taking the time to post here in the Community, bettyb3.

I'm happy to provide some info to make entering payments to your QuickBooks Desktop account easier.

In this instance, I recommend checking out third-party apps that integrate directly with your QuickBooks account. By searching the Desktop Apps site I was able to find one for Authorize.net. 

Looking at the description, this may be just what you need - "Commerce Sync streamlines your bookkeeping, automating the transfer of Authorize.Net sales every night into QuickBooks. This saves time and money and lets you do what you do best—run your business."

You can find out additional details by following this link: Apps for QuickBooks Desktop

Don't hesitate to drop a comment below if you have any other questions. The Community always has your back!

Thanks for your response. I don't think that will work. The invoices are saved as a memorized transaction and the auto payment is saved as a recurring charge through Authorize.net so there is no invoice number attached to the payment (since it changes each month). I don't think that there would be a way for an automated app would know where to apply the money. 

Hi there, @bettyb3.

You can check with Authorize.net to see if there's a way to integrate it with QuickBooks Desktop (QBDT) so that your transactions will automatically sync. This would eliminate the need for you to manually import your data.

If integration isn't possible, you can use IIF files to import invoices and payments into QBDT. To learn more about the lists and transactions that can be imported, please refer to this article:  Export, import, and edit IIF files.

Remember to back up your company file before importing IIF files. If you ever run into problems, you can use your backup to restore your data. Here's how to import:

For QBDT for Windows:

1. Sign in to your company file as an admin. Ensure you're in Single-user Mode.

2. Go to the File menu, then select Utilities.

3. Click on Import, then select Import IIF.

4. Choose the IIF file you want to import and click Open.

5. Select OK to confirm the import.

For QBDT for Mac:

1. Sign in to your company file as an admin.
2. Go to File, then select Import.
3. Select From IIF Files, and then export your IIF file.

Please note that there's a limit to the number of list items you can import. For more details, please see this article: Maximum number of list entries.

Also, keep in mind that when you import IIF files, transactions aren't automatically linked. You'll need to link the invoice with its corresponding payment after the import.

If you have any additional questions, just click the Reply button below.

@bettyb3 

It looks like you need a 3rd party app to do that.  I have no affiliation with them, but look at Commerce Sync:

https://www.commercesync.com/ 

They offer a free trial, and it's $17.95/month if you decide you like it.  

@bettyb3 

They also limit the third-party apps that are allowed to sync with QB Desktop. Alternatively, you can use the importer tool and its license is $200 one-time. If you meet the requirements, you can get it for free.