Sorting out Aetna Revenue

[kwallis957]

I have a problem that maybe Square can help me with. I use the service to charge all virtual cards. Aetna (in their infinite wisdom) decided to NOT send 1099 forms. They are telling me that the data is on 1099K. WHERE?

Is there any way to break out from the 1099K form (sent by Square), how much money came from Aetna?

[Summer2024 · Accepted solution]

Hi, @kwallis957 ! Welcome to the Square Community! 

Your 1099-K from Square shows the total amount of card transactions processed through your account during the tax year. It’s purely based on payment volume. That’s because Square only sees card details and transaction metadata, not the origin of the funds or the business name tied to a virtual card.

So, even though Aetna says “your 1099 data is on your 1099-K,” what they mean is, those payments were made via virtual credit card processed through Square, so they’re included in your Square gross volume, but not broken down separately.

However, you can find those transactions manually or through an export following these steps:

1. Go to your Square Dashboard → Transactions.

2. Use the Search bar to type keywords like “Aetna,” “virtual,” or any part of the payer name that appears on the card statement.

3. If Aetna’s payments use a consistent card prefix or descriptor, note it.

4. Export your Transactions CSV report for the full year.

I hope this helps. Let me know if you have any other questions. 

1. In Excel or Google Sheets, filter or search for that card descriptor or prefix to sum up the total Aetna payments.