Solved: Should I import the Transaction Date or the Date Posted on a CSV file?

The bank probably have that transaction marked as “pending” on 30 September, and “cleared” on 2 October. Personally, I use the earlier date in Quicken so that it looks like I lose money earlier. This isn't 100% accurate, but it keeps me from thinking my accounts have more money than they would otherwise have. For cash withdrawals and deposits, I'd just use the date when you make the withdrawal, since that is the day from which the money is available in the new location rather than the old one. Personal Finance & Money Stack Exchange is a question and answer site for people who want to be financially literate. Erika Rasure is globally-recognized as a leading consumer economics subject matter expert, researcher, and educator.

Credit card accounts can be especially important for understanding the post date. The post date on a credit card account can affect the interest charged in a particular statement period. That's because the card company recognizes that balances are paid off sooner.

The transaction reversal 'Correction' option in the General Ledger parameters of D365FO (or AX)

As a general rule, credit card issuers must post a payment on the day they receive it. However, the federal Office of the Comptroller of the Currency (OCC) notes, "the bank may set reasonable requirements for receiving payments. For instance, the bank may set a cut-off time." One exception, however, is when the cardholder makes their payment to the credit card issuer. If the cardholder pays too close to the due date, their payment may not post in time, and they can be subject to late fees and even see their credit score take a hit. If you have concerns about a purchase—for example, you were charged the wrong amount—you have a small window of time to have the business void the transaction and correct it.

Credit cards frequently come with introductory offers and terms, and you’ll need to track when these offers end. Offers may include balance transfer offers, introductory interest rate offers, and sign-up offers. Regular way transactions settle on the second business day after the trade date, which is referred to as T+2.

  • The post date is the day, month, and year when a card issuer posts a transaction and adds it to the cardholder’s account balance.
  • Your credit card payment due date will be the same each month, making it easy to plan for, but that might not be a good thing if you have another large payment due on that same date or if you regularly get paid a week later.
  • This timing discrepancy can sometimes catch cardholders off guard, as they might expect the transaction to reflect on their account immediately.
  • After all, missing your due date could result in a late fee as well as your being charged a penalty APR.

For a credit card transaction, this will reduce the available credit balance by the purchase amount. For a debit card transaction, the account holder will see a reduction in their available funds. Credit card payments may be posted the same or next day, depending on the timing of your payment and your card issuer's policies.

Davey, who did later meet Bates in October 2010, has said he regretted not doing more at the time and claimed that Post Office executives had blocked him from meeting campaigners. More than £130m has so far been paid out to about 2,500 Post Office workers across the three schemes. However, last month it emerged that the Post Office had almost halved the amount set aside for payouts as fewer owner-operators than expected had won or brought appeals. Because each time you run the Inventory value report you have to select the dates for the inventory data to present. Especially the ending date is important to be able to present the data related to an 'as of' date. Ledger is a command-line double-entry accounting tool that has inspired dozens of clones and a great ecosystem for tracking and analyzing finances, commodities, time tracking, and more.

The Post Office is now box office as inquiry resumes with righteous fury

When you select the option 'Transaction date' in the report setup, the data in the report will not be calculated based on the used posting date in the journal line, but based on the moment when the transaction was posted. There are other accounting rules that require you to not record your income until a certain event happens after you receive the actual income. You can see this in company financial reports where they discuss the timing differences between receiving funds and recognizing income.

What Is Original Credit Transaction

For example, if your credit card issuer posts payments made before 5 p.m. In the time zone indicated on the bill on the same business day, a payment made at 6 p.m. Because of the way credit card transactions are processed, it may take a few days for transactions to post to your account. When you swipe your card or make an online purchase, the business authorizes the transaction by checking with your card issuer to make sure the card is valid and the funds are available. Once the transaction is sent to the credit card issuer for payment to the merchant, the transaction posts to your account.

Isn't this a really challenging way to budget, given that I have no control over when charges clear, only when I make them? In QBSE, importing CSV files can be done using a 3-column (Date, Description, and Amount) or 4-column (Date, Description, Credit, and Debit) format. You'll want to use the transaction date since it's the day the transaction is created. However, I'd recommend seeking advice from your accountant to verify which date is appropriate to use. For my personal financial accounts, I use whatever I think makes sense at the moment which, for me, is almost always to use the earlier date.

When Consumers Need to Pay Attention

As a cardholder and responsible steward of credit, you’ll also need to keep track of an array of important credit card debts, some more important than others. I recently tried to get started with YNAB using bank import, and I realized that charges were showing up in YNAB based on when they clear my account (cleared/posted date), vs. when I make the purchase (transaction date). I emailed support and they said this is just how it works, unless you enter the transactions manually, in which case they should match with the transaction date. It’s my understanding that the transaction date is when the system first tries accessing the funds, but the account doesn’t yet reflect the difference in balance.

She is a financial therapist and transformational coach, with a special interest in helping women learn how to invest. Sir Ed Davey, the Liberal Democrat leader, has also come under increasing criticism for his lack of action when he was postal affairs minister between 2010 and 2012, when the software issues started coming to light. There have been calls for former Post Office boss Paula Vennells, who was chief executive for much of the period during which the postmasters were wrongly pursued, to be stripped of her CBE. On Friday, the Metropolitan police confirmed for the first time that the Post Office is under criminal investigation over “potential fraud offences” committed during the scandal. By last month, 142 appeal case reviews had been completed out of 900 people convicted during the scandal, with 93 convictions overturned and 54 upheld, withdrawn or refused permission to appeal.

Should I import the Transaction Date or the Date Posted on a CSV file?

This timing discrepancy can sometimes catch cardholders off guard, as they might expect the transaction to reflect on their account immediately. However, delays in posting can occur due to various factors, such as weekends, holidays, or merchant processing times. Or later, and "payments received after the established cut-off time will generally be credited as of the next business day." If card issuers do impose a cut-off time it should be specified in their credit card agreements.

However, you need to act quickly, as the interval between the time a transaction occurs and when it is posted can be brief. After a transaction posts to your account, you can return the merchandise and ask the merchant for a refund. If you never received the product or service, or if it was unsatisfactory, you can request a chargeback with your card issuer. The cash flows from financing activities simplification comes from assuming transactions take no time to transfer from one account to another, and are instantly available after that. Your book-keeping software probably books using this simpler basis for your personal finances. In the financial world, there are many different dates to be aware of as they play a different role in the ownership process.

דילוג לתוכן