Post & Transaction Dates Reported on Separate Rows for One Transaction

I have a issue with my credit card transactions and my linked spreadsheets. When I download the transactions from the credit card company, they show both the “transaction date” and the “post date” on different rows for the same transaction. This means that I am counting the same transaction twice in my spreadsheets, right? This affects all the worksheets that pull data from the “transaction worksheet”. How can I avoid this double counting issue?

I saw this once with one of my old transactions. It turns out for some reason, the sheet was pulling in two “accounts” when only one was needed. Check the accounts and see if you have a duplicate. I know Chime does this.