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. 

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.

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.

"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?

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.

"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.

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

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

I'm glad to hear that the assistance was beneficial. Collaborating with an outsider can often provide valuable insights into your own data flow concepts. Thank you for your positive feedback! If you have any more questions or need further assistance, feel free to ask.cotton candy t shirt full sleeve