Clive Woodhouse

Various Thoughts

OR: How to solve the dreaded "Can't remove the ID from the split definition in the middle of the import file"

PayPal seems to do a terrible job of exporting history files to the Quickbooks iif format  I usually get a "Can't remove the ID from the split definition in the middle of the import file" error when importing into Quickbooks Pro 2013.  Here is a work-around that I managed to figure out.

To download my PayPal transactions into a "PayPal" account created in Quickbooks' "Chart of Accounts" I go into my transactions in PayPal then select the downloads link.  This opens the Download History window where I select a date range and select "Quickbooks (.iif)" from the dropdown menu.

Once the file downloads open it with Excel as a tab delimited file.  The original file creates an error because it is missing a SPLID column.  In Excel insert a new column before column B with the "DATE" header.  In this new column B insert "TRNSID" in B1 and "SPLID" in B2 (without quotes).

If you wish to have the transactions imported as cleared you can also do the following.  I prefer this so I can distinguish these newly imported values from existing data to help manually balance the account.  You should now have a column H with "MEMO" as the header.  In column I add "CLEAR" to both I1 and I2.  Then, in I3 add the formula "=IF(ISBLANK(F3),"","Y")".  Copy this down to all the data rows.  This will add a "Y" for any rows that have a transaction in them.  Your spreadsheet header should look like this.

Quickbooks spreadsheet example

Save the spreadsheet, making sure it retains its original tab delimited (text) format and not as an Excel file.  For safety, backup your Quickbooks file before attempting an import.Now import this into Quickbooks as an iif file and everything should work.

 

Leave your comments

Post comment as a guest

0

People in this conversation

Load Previous Comments
  • Guest - Shileng

    http://tygodnikmakowski.pl/forum/viewtopic.php?f=2&t=314&sid=419dcdec301e49986bb036bd88047632 Who doesnt want bright and white teeth? It can be a welcome manifestation of good hygienic practice and automatically makes anyone the you with a positive environment. The need for lightening has become prevalent because we normally do never pay attention to our own teeth until we see some visible stains which have been cumbersome and / or impossible get rid of with normal brushing. However, hope is not lost you can apply available home whitening gels that will save you from embarrassment. It is safe and effective once you follow the instructions protected by the lot. In this article great see the facts of home whitening pastes.

    0 Like Short URL:
  • Guest - Monica

    http://www.nieznanaukraina.pl/przyjaciele/uzytkownicy/alexa/profile/ Take Care of Yourself Many people, especially women, feel their sexual energy fade as they become less satisfied using appearance. A person unhappy with those few pounds youve gain recently? Has stress ravaged the skin? Did your first grey hair emerge? Have you noticed you arent taken time for with care these working weeks? You have control just about all of these aspects of all time! Instead of letting the way you look go, devote the effort to be look and feel higher quality. Whether its going on the gym or getting a brand-new haircut, try something that causes you feel your best. Not only will you see the difference, but your better half will also appreciate the time and effort.

    0 Like Short URL:
  • Guest - David

    http://ronsard-poitiers.fr/author/spislavi/ But do not despair within your battle get rid of and maybe even reverse grey hair. There are a few safe herbal solutions onto your problem. And find this that take 5 to 8 months to view results. Rather something like 8 to 12 weeks instead. Such products are loaded with super premium vitamins for grey hair, that effectively beat back the greying.

    0 Like Short URL:
  • Guest - Jason

    http://www.elutec.co.uk/author/restiobo/ Why wouldnt you would like to try Easy White Pro? Shed benefits to having beautiful, white teeth. It enhances your smile and visual appeal. You look younger and more rejuvenated. People will see you differently. This will assist improve your appearance when in involves interviews and dates.

    0 Like Short URL:
  • Guest - Trisha

    Ranking najlepszych preparatów na ból stawów i mięśni http://depresja-leki.pl/kolejny-nieskuteczny-suplement-atarax-opinie-po-stosowaniu/

    0 Like Short URL:
  • Guest - Andrew

    0 Like Short URL:
  • I was on your website and reading your blog. You have shared very informative blog for everyone. Please keep update from
    your more blogs. Thanks for sharing this with me. roll stickers

    0 Like Short URL:
  • Guest - Kristen

    https://www.agltechnologies.com/profile/torin85/ No one likes to share with you it, but more than 50% of Americans over 50 suffer from hemrrohid or some call it Piles discomfort. You do not have to regarding it bu you reason to become more educated about possible alternatives. I want to help education a serving of the islands who solicit more.

    0 Like Short URL:
  • Guest - Lauren

    https://www.thebandaidroom.com/profile-2/fecmetdou24/ Having a white smile is desire many people dream of. The fact is that a perfectly white smile change to obtain. Our teeth can seriously be affected by anything we devote our mouth.

    0 Like Short URL:
  • Guest - Kelli

    This week we learned the Roman Curia, its cardinals and http://technocare.lk/community/profile/yoshihi30/ pope, won't self-convict. They won’t even self-investigate.

    0 Like Short URL:
Template Settings

Color

For each color, the params below will give default values
Blue Red Oranges Green Purple Pink

Body

Background Color
Text Color

Header

Background Color

Footer

Select menu
Google Font
Body Font-size
Body Font-family
Direction