Both my company and the developers we work with are having issues getting credit memos to import in iif files. Bills and other transactions work fine using the same format.
Here is an example. Trying to import this file gives an error "Error on Line 6: Can't record invalid transaction".
!TRNS TRNSTYPE ACCNT AMOUNT DATE NAME DOCNUM MEMO
!SPL TRNSTYPE ACCNT AMOUNT DATE NAME DOCNUM MEMO
TRNS CREDIT MEMO Accounts Payable -0.51 11/28/2018 Sysco [removed]
SPL CREDIT MEMO Dining - food & beverage:Raw food 0.51 20181128
Thank you in advance for any assistance.
If this transaction really is an AP transaction - a credit from a Vendor, then the correct TYPE is "BILL REFUND" and not "CREDIT MEMO"
It may be useful to you to use our BRC IIF Transaction Creator Pro to create excellent example IIF files which you can pattern match.
Here is a example of a file I want to do a credit memo on. Can someone help me find the correct format? It was a invoice.. but I want to experiment with it to import as a credit memo.. but having a problem finding out what I am missing.
TRNS CREDIT MEMO 3/5/2019 Accounts Receivable ICE:CONSTRUCTION INDUSTRIAL POLY ONE #438 64.5 Terms 60 Days N TERMS POLY ONE CORPORATION AP DEPT P.O. BOX 90 AVON LAKE, OH 44012 Polyone #438*>< 33587 Walker Road Avon Lake, OH Y PO4658150 [removed] 5/4/2019
SPL CREDIT MEMO 60100-Sales:60101-Sales-Ice POLY ONE #438 -52.50 3.50 -15 22 POUND BAGGED ICE 22 Pound Bag N ICE:CONSTRUCTION INDUSTRIAL
SPL CREDIT MEMO 60100-Sales:60101-Sales-Ice POLY ONE #438 -12.00 12.00 -1 DEL FEE FLAT 12 DEL. FEE ($12.00) N ICE:CONSTRUCTION INDUSTRIAL
SPL CREDIT MEMO SALES TAX PAYABLE Treasurer of State 0.00 0.0675 LORAIN SALES TAX Sales Tax AUTOSTAX Y
It came back that I can't import a negative value into a credit memo.. so I guess I am on the right track. I tried changing values from positive to negative.. no luck. So if anyone can give assistance on this.. that would help alot.
Hello there, @Iceguy.
I'd be delighted to share additional details on how you can import your credit memo.
To download a sample IIF file with a correct format in importing credit memo, you may check out article: IIF Overview: import kit, sample files, and headers.
You can also import these credit memos using Batch Enter Transactions. Here's how:
That should do it! Feel free to visit us here in the Community if you have other questions about importing batch transactions. I'm always here to help.
Hi there, @Iceguy,
Thanks for getting in touch with us today. I can add a bit more about importing credit memos in QuickBooks.
You're doing the right thing with mapping the transactions. Before importing, you can use our sample IIF files to compare your entries. It contains transaction data and the associated list data to guide you how to combine several types of data in one IIF file. Click the links below:
Please use a WinZip or a compatible file compression utility to get the contents of the downloaded file.
You can also check this article to know more about importing the transactions in QuickBooks: IIF Overview: import kit, sample files, and headers
Once you have the file ready, you can not start uploading the IIF file. Here's how:
That should get you on the right track, @Iceguy.
Please let me know if you have any questions. I'm here if you need further assistance. Have a great day!
How do you import an IIF file with a tax only credit memo. i was able to import an invoice, but the same setup for a credit memo does not work. If i use the tax group it says the item is the wrong type. if i use the tax items it says i have an invalid reference to the tax item. I tried the "i'll fix it later" link but that just says it is an invalid transaction.
I'm attaching a file with an example of each. Maybe i'm missing something.
-Thanks in advance.
I'd be glad to assist you with importing credit memos in QuickBooks Desktop, arnierudy.
I appreciate the screenshot you've provided. To import the transactions via the IIF file successfully, you must check the file first. Double-check the account names used, the spelling, and any other typographical errors. You must ensure that the names used exist and are acceptable in QuickBooks.
Also, be sure to select the correct items and their corresponding accounts. Once you're done checking the file, you should be able to import the credit memo seamlessly.
For more information about the process, check out this article: Export, import, and edit IIF files. On the same link, you’ll also find different transactions and lists you can import using the IIF file type.
Additionally, in case you need help with importing your customers and vendors via the CSV file, you can read through this article: Import/export CSV files.
You can always reach out to me if you have additional questions about the importing process or anything in QuickBooks Desktop. I'm always ready to lend a helping hand.