IIF Memo Field and import

parker5095 · ‎November 27, 2022

I have import working fine (older per-2019 Desktop version). I wanted to change the memo on the SPL line but it when I import it has the memo from the TRNS line. I'm trying to have the transaction indicate something like Payment to and the SPL to indicate Payment from. I've looked at the IIF Import Kit and it provides no guidance.

Is there a different field to use for Memo in SPL within the IIF? I can change it manually in QB.

@BigRedConsulting I feel like you know most about this Thanks for your help in advance. If I ever need a full solution, your web page is in my bookmarks.

BigRedConsulting · ‎November 27, 2022

Both the TRNS and SPL type rows have a MEMO field. If you put different values in them, those values will both import for most types of transactions (those that have more than one memo.)

View solution in original post

BigRedConsulting · ‎December 10, 2022

Yes, a Transfer transaction appears to have only one memo field, and so while you can specify a SPL memo, it appears to be ignored when you import - as there's no place for it to be saved.

You could use a check or a journal or a deposit transaction instead, all of which have multiple fields and which will work the same from an accounting point of view.

View solution in original post

JaeAnnC · ‎November 27, 2022

Thanks for reaching out to us, @parker5095.

Let me provide you with tips so you can successfully change the memo on the SPL line when importing .IIF files in QuickBooks Desktop (QBDT).

First, we have to ensure that a correct format is followed. To do that, QBDT has recommended sample .IIF files we can download to use as templates for importing transactions.

Since you've utilized them already, I suggest reaching out to your IT professional. Intuit doesn't offer assisted technical support for creating or importing .IIF files, thus, we're unable to identify if there's a different field to use for Memo in SPL.

In addition, we may also look for third-party apps that may help you with your concern.

I'm also adding an article for you to learn about a more convenient and accurate way of importing .IIF files: Improved IIF Import in QuickBooks 2019 and later. This way, it scans your file for errors which prevents importing bad data to your QuickBooks.

Feel free to leave a reply if you have additional questions about importing .IIF files to QBDT. We're always here to provide our assistance. Stay safe!

BigRedConsulting · ‎November 27, 2022

Both the TRNS and SPL type rows have a MEMO field. If you put different values in them, those values will both import for most types of transactions (those that have more than one memo.)

parker5095 · ‎December 10, 2022

I'm focused on transfers. So if the IIF has this:

TRNS 66467 TRANSFER 1/1/2022 Bank A 100 N Transfer from Bank B

SPL 66467 TRANSFER 1/1/2022 Bank B -100 N Transfer to Bank A

Then what I end up with is both bank accounts have a memo with Transfer from Bank B.

Is that the limitation of this in QB for transfers?

BigRedConsulting · ‎December 10, 2022

Yes, a Transfer transaction appears to have only one memo field, and so while you can specify a SPL memo, it appears to be ignored when you import - as there's no place for it to be saved.

You could use a check or a journal or a deposit transaction instead, all of which have multiple fields and which will work the same from an accounting point of view.

Topics

Training

Community

Resources

IIF Memo Field and import