Avatar of Berkson Wein
Berkson WeinFlag for United States of America

asked on 

Quickbooks Import IIF: show what was just imported

Hi all

I've got a user who regularly imports transactions into Quickbooks 2011 by importing an IIF file.  It works fine.

What she's wondering is if there's a way to run a report to show transactions that were imported on a given day (or date ranges).  Being able to do this would allow her to compare what the system that generates the iif says should be imported with what QB says was actually imported.

Doable?

Thanks.
QuickBooks

Avatar of undefined
Last Comment
John
SOLUTION
Avatar of John
John
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of QBalance_QuickBooks_Advisor
QBalance_QuickBooks_Advisor
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Berkson Wein
Berkson Wein
Flag of United States of America image

ASKER

Thinkpads_User: the transaction date won't be a viable option.  There's transactions that are entered regularly into QB, the IIF import is just additional transactions from another system.

The custom field is an interesting option.  Have more info on that?

Linda: the date ENTERED is a good start.  That won't help identify only those imported fields though, since there will be manual entries on the same day.

If I could get the custom fields into the IIF, say a field that has the data "imported from external system" or something, then I could do a report by date entered and only show those entries that have "imported from external system" in the custom field.

I'd love a pointer on how to accomplish that.  I know how to do a memorized report and put in the criteria, what I don't know is how to create the custom fields.

THANKS ALL!
ASKER CERTIFIED SOLUTION
Avatar of John
John
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
Avatar of John
John
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of John
John
Flag of Canada image

Hello weinberk - Any update?   ... Thinkpads_User
Avatar of Berkson Wein
Berkson Wein
Flag of United States of America image

ASKER

I think we're either going to go with a different user or using a different general ledger code.  Thanks for your help!
Avatar of John
John
Flag of Canada image

Thank you, and I was pleased to help you with this. Good luck going forward.

.... Thinkpads_User
QuickBooks
QuickBooks

QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.

2K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo