Date error importing IIF files for PayPal

hotelathome · October 2016

Error on Line 4: Imported record has an invalid date. It should be MM/DD/YY

I am using Reckon Accounts Hosted Edition 2016

I have always gone to my PayPal account, and downloaded all my transactions as iif files, then uploaded them to Reckon Accounts Hosted, and then imported the files as iif files.

This is the first time I have ever seen this warning. I tried changing the general date preferences in Reckon, unticking the "show date format as 4 numbers" but this hasn't helped.

I really need to import my paypal transactions.

PhuongDo · October 2016

Can you share a sample IIF file ? or the date value that you have in your IIF ?

hotelathome · October 2016

I'm not sure how to open an IIF file, to look for the date value.

PhuongDo · October 2016

If you are using Windows, you can open Excel, then drag the IIF file to Excel window, you will be able to see the data in a proper layout.

hotelathome · October 2016

I also cannot find a way to upload a copy of my iif file to this forum

PhuongDo · October 2016

You can send the file to my email at phuong@quickbooks.vn. I can take a look and let you know.

hotelathome · October 2016

!TRNS DATE ACCNT NAME CLASS AMOUNT MEMO !SPL DATE ACCNT NAME AMOUNT MEMO
!ENDTRNS
TRNS "14/07/2016" "PayPal Account" "Martha Schafer" "Website Payment" 87.36
SPL "14/07/2016" "Sales" "Martha Schafer" -90.00
SPL "14/07/2016" "PayPal Fees" Fee 2.64
ENDTRNS
TRNS "15/07/2016" "PayPal Account" "ANTHONY DICKENSON" "Website Payment" 218.85
SPL "15/07/2016" "Sales" "ANTHONY DICKENSON" -225.00
SPL "15/07/2016" "PayPal Fees" Fee 6.15
ENDTRNS
TRNS "17/07/2016" "PayPal Account" "Kitty Parker" "Website Payment" 106.84 "wId:57750431"
SPL "17/07/2016" "Sales" "Kitty Parker" -110.00
SPL "17/07/2016" "PayPal Fees" Fee 3.16
ENDTRNS
TRNS "18/07/2016" "PayPal Account" "" "General Withdrawal" -3 000.00
SPL "18/07/2016" "PayPal Fees" "" 3 000.00
ENDTRNS
TRNS "18/07/2016" "PayPal Account" "Alison Smart" "Website Payment" 209.11 "wId:57750431"
SPL "18/07/2016" "Sales" "Alison Smart" -215.00
SPL "18/07/2016" "PayPal Fees" Fee 5.89
ENDTRNS
TRNS "28/07/2016" "PayPal Account" "Yvette Nash" "Website Payment" 53.76
SPL "28/07/2016" "Sales" "Yvette Nash" -55.50
SPL "28/07/2016" "PayPal Fees" Fee 1.74
ENDTRNS

PhuongDo · October 2016

OK, so the date value in your file has DD/MM/YYYY format, and Reckon expect to read it as MM/DD/YY, so instead of 28/07/2016, it should be 07/28/2016

hotelathome · October 2016

So do I need to edit my Reckon file to accept DD/MM or do I need to do something in PayPal so that it will download in the correct date format?

PhuongDo · October 2016

There is nothing you can do with Reckon, you will need to change in Paypal (I'm not sure how yet) or manually change the IIF file.

hotelathome · October 2016

Thank you. I have been importing in this manner for years, and now all of a sudden, the date format has changed in Reckon. Looking at all my previous iif files, they have always been presented in the DD/MM format. Now all of a sudden, I need to reformat the files into MM/DD format.

hotelathome · October 2016

Wait, my apologies!!! Just checked previous iif files and they were all in the MM/DD/YYYY format, so PayPal must have changed the format for downloading. I'll contact PayPal, and if I find a solution, I'll post it here

PhuongDo · October 2016

Cool, good luck

hotelathome · October 2016

The DD/MM/YYYY is now hard wired into all iif file downloads, if you are an Australian PayPal Customer. There is no way to change the date format, short of trying to change it in excel and then changing it back to an iif File.

Kailey · April 2018

Hello, I have the same problem but when I look at the IFF file in excel the dates are already MM/DD/YY. Any advice on how to fix this?

Date error importing IIF files for PayPal

Comments

Categories