cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

IIF Import

I’m learning to use the IIF import for cash sales and deposits.  I’ve successfully imported the transactions but find that “Banking”, “Make Deposits” shows them available or uncleared even though undeposited funds is zero.   Is there any way to match up/clear these transactions in the IIF import?

Solved
Best answer August 15, 2017

Best Answers
Highlighted
Anonymous
Not applicable

IIF Import

Hi LaundryYard, 

 

I think that the issue is in the Cleared column. If you have that header,  make sure to change the N to a Y  for each transaction.  

 

 

cleared.png

 

Here are a few other tips that may help you along the way:

 

  • Never import an IIF without backing up your data first because the process is irreversible
    • When working with IIF files, I normally work out of a copy of the company file until I get the results I want. Then I re-import to the working file after backing it up
  • For large amounts of data, I prefer to use a transaction importer, or if using QuickBooks  Desktop Accountant, I use the Batch Import Transactions tool 

View solution in original post

9 Comments
Highlighted
Anonymous
Not applicable

IIF Import

Hi LaundryYard, 

 

I think that the issue is in the Cleared column. If you have that header,  make sure to change the N to a Y  for each transaction.  

 

 

cleared.png

 

Here are a few other tips that may help you along the way:

 

  • Never import an IIF without backing up your data first because the process is irreversible
    • When working with IIF files, I normally work out of a copy of the company file until I get the results I want. Then I re-import to the working file after backing it up
  • For large amounts of data, I prefer to use a transaction importer, or if using QuickBooks  Desktop Accountant, I use the Batch Import Transactions tool 

View solution in original post

Highlighted
Level 1

IIF Import

Thanks John for the suggestions.  I'll take a looked at the cleared column and see if that will give me the desired result.  I don't have large amounts of data to import so hopefully the IIF files will get the job done. 

Highlighted
Level 15

IIF Import

I recommend this Method, instead of .iif:

Daily Sales Summary for Retailers by Long

 

You set that up as a worksheet and Memorize it, so that you can Double-click it and it opens, like a Preprinted worksheet, every time.

 

If you use .iif, please note this is Not integrated, after import. You would include Rebuilding this data file, to make the data truly Linked into the relational database.

 

You do Not want any transaction to be marked  Clear, with the import. Clear is part of the reconciliation process. UF is a Self-reconciliating and self-managed account. You never work in its register, nor Clear its entries yourself.

 

The other issue is that the .iif might be using UF incorrectly. You really don't use it manually, and you don't use it for generic amounts. In other words, a Deposit doesn't go To or From UF as .iif at all. UF is tied to the functions, and posting to UF via a .iif creates a condition of Unrelated amounts.

 

Examples of what doesn't Work:

JE for Sales, ending with amounts to UF, then one Entry removing the total from UF. That's because UF wants to Self-manage that as individual entries. In this example, there was no need to run that through UF at all.

 

Examples of your code, and explanation of the intent, would be helpful.

Highlighted
Level 1

IIF Import

My intent is to use the IIF import for cash sales and deposits.  Seems like the transactions should go through UF as the sales date is slightly different than the bank deposit date.  I can import both the deposit and sale using IIF but "Banking Make Deposits" stills shows them as available or uncleared.  I was attempting to make the job eaiser but I'm finding that the IIF function may not give me the desired results.

Highlighted
Level 15

IIF Import

"My intent is to use the IIF import for cash sales and deposits."

 

We need to see the coding.

 

"Seems like the transactions should go through UF as the sales date is slightly different than the bank deposit date."

 

Yes, you would flow the data to UF for a Holding process.

 

"I can import both the deposit"

 

But here is the issue, most likely, because you are trying to Make the deposit as part of the .iif, which isn't the same as Using UF to process it.

 

"and sale using IIF but "Banking Make Deposits" stills shows them as available or uncleared."

 

Yes, they Should Be Uncleared. What you should see, if the import is coded properly, is the Negative and the Positive both in the Make Deposit pop up.

 

You won't "empty out UF" by Not Having entries in UF. That is my point re Self-Managing and Self-Reconciling. You will have Two Unrelated Entries. You need to Process them.

 

"I was attempting to make the job eaiser but I'm finding that the IIF function may not give me the desired results."

 

Integrated tools are beneficial when another Program prepares them. Doing this manually means all of that preparation you did outside of QB could have been done Inside it, already.

 

Did you look at the Sales Receipt Method I linked?

Highlighted
Level 1

IIF Import

Ok, I see your point about self managing/self reconciling and UF.  I did review your link.  Not sure if it will work as I'm wanting to enter the daily transactions once a week with the individual dates as opposed to a daily summary.

 

I appreciate your help/suggestions.  For now you've done all you can do.  Maybe I'll use the IIF import for my sales transactions and use "Banking Make Deposits" for deposits so I won't have uncleared amounts in UF.

Highlighted
Level 15

IIF Import

"and use "Banking Make Deposits" for deposits so I won't have uncleared amounts in UF."

 

My recommendation is to make your Own Bank Type of account and name it Clearing. Put your data there, directly, and make a transfer from there to real checking, and stop using UF.

Highlighted
Level 1

IIF Import

Great idea.  A clearing account and stop using UF will be my ticket to happiness.  Thanks for you help.

Highlighted
Level 15

IIF Import

Glad it helped. Sometimes, it takes an outsider to work with you through your own data flow concepts.

Need to get in touch?

Contact us