Date changes on Import from CSV to Tracking Account

Hi I'm using YNAB for our business and created an A/P tracking account.  I exported my A/P from QB as a CSV file.  The payables transactions include future dates (obviously).  When I import the CSV file into the tracking account any future dates are automatically changed to today.  Is this an error in YNAB?  Does anyone know of a fix for this?

10replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Anyone else have this issue?

    Like
  • Hey Bruce ! Future dated transactions from a CSV (or other file types) will import with today's date. This is by design. File-Based Importing was created with importing bank transactions in mind (transactions that have already occurred).

    Were you expecting to see those import and become Scheduled Transactions in YNAB? Or something else? Our Product team would love to hear more about what you are hoping to see, if you're up for submitting a Feature Request.
     

    Like
      • Bruce
      • Timber Products
      • bruceh
      • 2 mths ago
      • Reported - view

      Hi Nicole !  I'm using the CSV import to bring a QuickBooks accounts payable file into a tracking account in YNAB.  The accounts payable transactions have future dates related to them because they are not due yet.  I want to import the transactions with future dates so that when I look down my list of payables in the tracking account I know which day they are due and therefore when to pay them.

      I'm not bringing them directly into Scheduled Transactions.  But when I decide to pay specific bills, I'm transferring them from my tracking account to my checking account.

      Could you open up the available dates on imported transactions so that future dates can be used instead of changing future dates to the current date?

      I'll submit it as a feature request too.

      Like
    • Bruce Thanks for submitting the feature request! I can see how that would be useful. How often are you importing the accounts payable file?

      In a similar situation, I would try updating the imported transactions with the current date to the future date (becoming a Scheduled Transaction). That way, you'd have the chronological list to look through and when the date comes, it would drop into the register—so you'd have a signal to approve and move it to the checking account. It could be worth trying, and seeing if improves the current workflow. Playing with repeating, where needed, could be an option too!

      I'm going to pass on a link to this thread to a team member who has an interest in small business related conversations, to see if they have any other suggestions!

      Like
      • Bruce
      • Timber Products
      • bruceh
      • 2 mths ago
      • Reported - view

      Hi Nicole I'm importing weekly.

       

      Nicole said:
      In a similar situation, I would try updating the imported transactions with the current date to the future date (becoming a Scheduled Transaction).

      Yes, this is what I'm trying to accomplish.  However, I have to manually enter every date of every transaction because YNAB is changing them to today's date upon import. 

       

      I'll add repeating transactions where applicable (love this feature), but unfortunately it doesn't apply to many of my transactions.

      Like
    • Bruce Ah yes - that makes sense that it gets tedious to re-date those transactions! The feature request is just the right place for that info. 😊

      Like
  • I just came across another issue related to the date change.  When I import the accounts payable the following week YNAB considers all of the transactions as unique (not duplicates) because when it imports them, the date is changed to today, which is a different date than last week when I imported them.  So now I'm deleting 80%+ of the imported transactions because they're duplicates with a "new" date.

    Like
    • Bruce Ah yes! I can see how that could cause extra work. Are you able to narrow the range you import?

      Like
    • I guess you might not pick up new transactions that were added in the midst of the previous set, though. 🤔

      Like
      • Bruce
      • Timber Products
      • bruceh
      • 1 mth ago
      • Reported - view

      Marisa Correct.  I know I have QuickBooks as a backup, but I was hoping YNAB would catch the duplicates and just add the new Payables transactions.  If I import a smaller set, I've got to take the time to make sure I didn't let any fall through the cracks.

      Like
Like Follow
  • 1 mth agoLast active
  • 10Replies
  • 61Views
  • 3 Following