Spreadsheet: 844509d1696287931-beginner-reconciliation-help-required-to-define-transactions-into-categories-samplefile
Sheet: Pivot Data Table

 |  |  |  |  |  | -1 |  |  |  |  | -1
Source | Name | Date | Month | Location | Amount | Fees | Net | charge_id | reporting_category | description | gross | fee | net | created | Fixed Date
 |  | 2023-09-28 00:00:00 |  |  | 1000 | 35.5 | 964.5 | ch_3NuIGABOeJ90OU1D21DD4Vrj | charge | X - Order 42936 | 1000 | 35.5 | 964.5 | 2023-09-26 01:07:51
 |  | 2023-09-28 00:00:00 |  |  | 490 | 12.78 | 477.22 | ch_3NuNldBOeJ90OU1D0KyY8Dj6 | charge | Charge for [EMAIL] | 490 | 12.78 | 477.22 | 2023-09-26 07:00:42
 |  | 2023-09-28 00:00:00 |  |  | 1288 | 43.22 | 1244.78 | ch_3NuOaGBOeJ90OU1D0nDp2zpb | charge | for X, 2023-10-26, #3YK7UT7UN at LocationA | 1288 | 43.22 | 1244.78 | 2023-09-26 07:53:07
 |  | 2023-09-26 00:44:37 |  |  | 1 | 0 | 1 | ch_3NrCbXBOeJ90OU1D3CgPiFMp | fee | Application fee refund for ch_3NrCbXBOeJ90OU1D3CgPiFMp | 1 | 0 | 1 | 2023-09-26 08:44:37
 |  | 2023-09-26 00:44:37 |  |  | -2000 | 0 | -2000 | re_3NrCbXBOeJ90OU1D3uoYOIkJ | refund | REFUND FOR CHARGE (for X, 2023-10-08, #3BCYF4ALV at Location B) | -2000 | 0 | -2000 | 2023-09-26 08:44:37
 |  | 2023-09-29 00:00:00 |  |  | 2000 | 65 | 1935 | ch_3NuPPVBOeJ90OU1D4oXRwrSF | charge | for X, 2023-09-29, #3C7LMY5XB at LocationD | 2000 | 65 | 1935 | 2023-09-26 08:46:04
 |  | 2023-09-29 00:00:00 |  |  | 490 | 12.78 | 477.22 | ch_3NuPwGBOeJ90OU1D3KGJcEKR | charge | Charge for [EMAIL] | 490 | 12.78 | 477.22 | 2023-09-26 09:19:48
 |  | 2023-09-26 01:29:49 |  |  | 1 | 0 | 1 | ch_3NoIXpBOeJ90OU1D4RR8wQ1j | fee | Application fee refund for ch_3NoIXpBOeJ90OU1D4RR8wQ1j | 1 | 0 | 1 | 2023-09-26 09:29:49
 |  | 2023-09-26 01:29:49 |  |  | -2000 | 0 | -2000 | re_3NoIXpBOeJ90OU1D4EN7r4Tf | refund | REFUND FOR CHARGE (for Ms.[NAME], 2023-10-09, #3ALPWX593 at LocationE) | -2000 | 0 | -2000 | 2023-09-26 09:29:49
 |  | 2023-09-29 00:00:00 |  |  | 4000 | 137 | 3863 | ch_3NuQbcBOeJ90OU1D3lFzj0LE | charge | for X, 2023-10-05, #3C7SF83ZY at LocationF | 4000 | 137 | 3863 | 2023-09-26 10:02:41
 |  | 2023-09-29 00:00:00 |  |  | 1000 | 33 | 967 | ch_3NuR9fBOeJ90OU1D4lNQU8ik | charge | X - Order 42940 | 1000 | 33 | 967 | 2023-09-26 10:37:44
 |  | 2023-09-29 00:00:00 |  |  | 888 | 21.54 | 866.46 | [NAME] | charge | X - Order 42941 | 888 | 21.54 | 866.46 | 2023-09-26 10:49:14
 |  | 2023-09-29 00:00:00 |  |  | 350 | 9.7 | 340.3 | [NAME] | charge | Charge for [EMAIL] | 350 | 9.7 | 340.3 | 2023-09-26 10:53:42
 |  | 2023-09-29 00:00:00 |  |  | 700 | 23.7 | 676.3 | ch_3NuRmBBOeJ90OU1D1uwdHpik | charge | Charge for [EMAIL] | 700 | 23.7 | 676.3 | 2023-09-26 11:17:31
 |  | 2023-09-29 00:00:00 |  |  | 700 | 17.4 | 682.6 | ch_3NuSAWBOeJ90OU1D4YUWzW6K | charge | Charge for [EMAIL].X | 700 | 17.4 | 682.6 | 2023-09-26 11:42:41
 |  | 2023-09-29 00:00:00 |  |  | 2000 | 47 | 1953 | ch_3NuSG2BOeJ90OU1D42EX6zC0 | charge | for X, 2023-10-08, #3C5AAP8FL at LocationA | 2000 | 47 | 1953 | 2023-09-26 11:48:29
 |  | 2023-09-29 00:00:00 |  |  | 640 | 21.84 | 618.16 | ch_3NuSQhBOeJ90OU1D0wE6oQl7 | charge | Charge for [EMAIL] | 640 | 21.84 | 618.16 | 2023-09-26 11:59:24
 |  | 2023-09-29 00:00:00 |  |  | 6000 | 189 | 5811 | ch_3NuSVWBOeJ90OU1D4yrSPy6K | charge | for X, 2023-09-27, #3C54TZ6LG at LocationB | 6000 | 189 | 5811 | 2023-09-26 12:04:31
 |  | 2023-09-29 00:00:00 |  |  | 1000 | 25 | 975 | ch_3NuSbhBOeJ90OU1D09lxPmmN | charge | for X, 2023-10-06, #38L6TR4GX at LocationD | 1000 | 25 | 975 | 2023-09-26 12:10:52
 |  | 2023-09-29 00:00:00 |  |  | 3000 | 69 | 2931 | ch_3NuShvBOeJ90OU1D3kWRkieq | charge | for X, 2023-10-19, #3C82US4WU at Location D | 3000 | 69 | 2931 | 2023-09-26 12:17:17
 |  | 2023-09-29 00:00:00 |  |  | 3000 | 103.5 | 2896.5 | ch_3NuU0zBOeJ90OU1D3Hrcoa7k | charge | for X, 2023-09-26, #3C883XAU3 at LocationB | 3000 | 103.5 | 2896.5 | 2023-09-26 13:41:06
 |  | 2023-09-26 05:56:44 |  |  | -24.75 | 0 | -24.75 |  | fee | [NAME] (2023-09-25): [NAME] for Fraud Teams | -24.75 | 0 | -24.75 | 2023-09-26 13:56:44
 |  | 2023-09-26 05:58:44 |  |  | -0.25 | 0 | -0.25 |  | fee | 3D Secure (2023-09-25): Lookup | -0.25 | 0 | -0.25 | 2023-09-26 13:58:44
 |  | 2023-09-29 00:00:00 |  |  | 4000 | 91 | 3909 | ch_3NuUQSBOeJ90OU1D3f4mgoMY | charge | for X, 2023-10-01, #3BD2BJNN at LocationD | 4000 | 91 | 3909 | 2023-09-26 14:07:22