Spreadsheet: 860680d1708688597-how-to-use-multiple-worksheets-to-list-categories-by-date-order-wgs-accounts
Sheet: Bank Account

Date | [NAME] | Category | Paid In | Paid Out | Balance | ↓ Reconciled with Bank App
2023-03-01 00:00:00 | Opening Balance |  |  |  | 12922.06 | R
2023-04-03 00:00:00 | [NAME] (final payment) | Gun Subs | 1003.5 |  |  | R
2023-04-10 00:00:00 | [NAME] (full payment) | Gun Subs | 1025 |  |  | R
2023-04-11 00:00:00 | [NAME] (full paymnet) | Gun Subs | 2050 |  |  | R
2023-04-11 00:00:00 | [NAME] (full payment) | Gun Subs | 2050 |  |  | R
2023-04-11 00:00:00 | Bridgers Farm Ltd | Birds |  | 4875 |  | R
2023-04-15 00:00:00 | [NAME] (full payment) | Gun Subs | 1025 |  |  | R
2023-04-18 00:00:00 | [NAME] (full payment) | Gun Subs | 1025 |  |  | R
2023-04-18 00:00:00 | [NAME] | Gun Subs | 1025 |  |  | R
2023-04-21 00:00:00 | [NAME] | Gun Subs | 500 |  |  | R
2023-04-24 00:00:00 | [NAME] | Gun Subs | 525 |  |  | R
2023-05-02 00:00:00 | [NAME] | Gun Subs | 1025 |  |  | R
2023-05-03 00:00:00 | [NAME] (Cover Crop Seed) | Cover Crops |  | 448 |  | R
2023-05-03 00:00:00 | [NAME] (full paymnet) | Gun Subs | 1025 |  |  | R
2023-05-06 00:00:00 | [NAME] | Gun Subs | 512.5 |  |  | R | *
2023-05-06 00:00:00 | [NAME] | Gun Subs | 512.5 |  |  | R | * one credit of £1025.00
2023-05-08 00:00:00 | [NAME] | Gun Subs | 512.5 |  |  | R
2023-05-08 00:00:00 | Smudge T-Smith (full payment) | Gun Subs | 1025 |  |  | R
2023-05-15 00:00:00 | [NAME] (full payment) | Gun Subs | 1025 |  |  | R
2023-05-21 00:00:00 | [NAME] (fertilizer) | Cover Crops |  | 1075.68 |  | R | *
2023-05-21 00:00:00 | [NAME] (table covering) | Catering |  | 25.95 |  | R | *
2023-05-21 00:00:00 | [NAME] (buggy fuel) | Maintenance |  | 37.39 |  | R | * one debit of £1,138.36
2023-05-22 00:00:00 | [NAME] (muck & fertilizing) | Cover Crops |  | 1414.8 |  | R
2023-05-23 00:00:00 | [NAME] (drilling & rolling) | Cover Crops |  | 624 |  | R
2023-07-11 00:00:00 | [NAME] (drinker) | Maintenance |  | 65 |  | R
2023-07-14 00:00:00 | [NAME] (final payment) | Gun Subs | 525 |  |  | R
2023-07-19 00:00:00 | [NAME] (final payment) | Gun Subs | 1025 |  |  | R
2023-07-19 00:00:00 | [NAME] (buggy fuel) | Maintenance |  | 48.69 |  | R | *
2023-07-19 00:00:00 | [NAME] (2lts [NAME] for gapes) | Feed |  | 156 |  | R | *
2023-07-19 00:00:00 | [NAME] (lid bungees) | Maintenance |  | 26.98 |  | R | * one debit of £231.67
2023-07-28 00:00:00 | Bridgers Farm Ltd | Birds |  | 4875 |  | R
2023-07-31 00:00:00 | [NAME] (final payment) | Gun Subs | 512.5 |  |  | R
2023-07-31 00:00:00 | [NAME] (final payment) | Gun Subs | 500 |  |  | R
2023-07-31 00:00:00 | Bartholomews (poult food) | Feed |  | 2073.5 |  | R
2023-08-03 00:00:00 | [NAME] (final payment) | Gun Subs | 512.5 |  |  | R | *
2023-08-03 00:00:00 | [NAME] (final payment) | Gun Subs | 512.5 |  |  | R | * one credit of £1025.00
2023-08-07 00:00:00 | [NAME] (feeders) | Maintenance |  | 60 |  | R | *
2023-08-07 00:00:00 | [NAME] (work party xps) | V&S Xps |  | 20 |  | R | * one debit of £60.00
2023-08-09 00:00:00 | [NAME] (final payment) | Gun Subs | 1025 |  |  | R
2023-08-21 00:00:00 | [NAME] (wheat, 2.52t @ £190/t) | Feed |  | 478.8 |  | R
2023-09-11 00:00:00 | BASC Membership | Insurance |  | 1078 |  | R
2023-09-14 00:00:00 | [NAME] (wheat, 2.6t @ £190/t) | Feed |  | 494 |  | R
2023-09-15 00:00:00 | [NAME] (for cash account) | Transfer |  | 219.7 |  | R
2023-09-27 00:00:00 | [NAME] (mileage - 400m x 45p) | V&S Xps |  | 180 |  | R | *
2023-09-27 00:00:00 | [NAME] (tip for poult delivery) | Birds |  | 10 |  | R | *
2023-09-27 00:00:00 | [NAME] (buggy fuel) | Maintenance |  | 76.17 |  | R | *
2023-09-27 00:00:00 | [NAME] (catering items) | Catering |  | 38.93 |  | R | * one debit of £305.10
2023-09-28 00:00:00 | [NAME] (pen repairs) | Maintenance |  | 60 |  | R
2023-10-04 00:00:00 | [NAME] (wheat, 2.7t @£190/t) | Feed |  | 513 |  | R
2023-10-09 00:00:00 | ATM for Cash A/C | Transfer |  | 300 |  | R
2023-10-31 00:00:00 | [NAME] (fuel contribution) | V&S Xps |  | 120 |  | R | *
2023-10-31 00:00:00 | [NAME] (cakes) | Catering |  | 15 |  | R | * one debit of £135
2023-10-31 00:00:00 | ATM for Cash A/C | Transfer |  | 300 |  | R
2023-11-02 00:00:00 | ATM for Cash A/C | Transfer |  | 200 |  | R
2023-11-06 00:00:00 | [NAME] (wheat, 2.7t @£190/t) | Feed |  | 513 |  | R
2023-11-21 00:00:00 | [NAME] (mileage - 100m x 45p) | V&S Xps |  | 45 |  | R | *
2023-11-21 00:00:00 | [NAME] (buggy fuel) | Maintenance |  | 41.18 |  | R | *
2023-11-21 00:00:00 | [NAME] (catering items) | Catering |  | 98.84 |  | R | * one debit of £185.02
2023-11-23 00:00:00 | ATM for Cash A/C | Transfer |  | 250 |  | R
2023-11-24 00:00:00 | ATM for Cash A/C | Transfer |  | 250 |  | R
2023-11-27 00:00:00 | ATM for Cash A/C | Transfer |  | 300 |  | R
2023-12-04 00:00:00 | ATM for Cash A/C | Transfer |  | 250 |  | R
2023-12-07 00:00:00 | [NAME] (pen maintenance) | Maintenance |  | 70.2 |  | R
2023-12-07 00:00:00 | Fylands Esate (Lodge use) | V&S Xps |  | 225 |  | R
2023-12-08 00:00:00 | [NAME] (bar restock) | Catering |  | 131 |  | R
2023-12-08 00:00:00 | ATM for Cash A/C | Transfer |  | 250 |  | R
2023-12-08 00:00:00 | Tesco (bar stock) | Catering |  | 16 |  | R
2023-12-12 00:00:00 | ATM for Cash A/C | Transfer |  | 250 |  | R
2023-12-18 00:00:00 | ATM for Cash A/C | Transfer |  | 300 |  | R
2023-12-27 00:00:00 | [NAME] (wheat, 1.8t @ £190/t) | Feed |  | 342 |  | R
2023-12-30 00:00:00 | ATM for Cash A/C | Transfer |  | 300 |  | R
2024-01-17 00:00:00 | ATM for Cash A/C | Transfer |  | 300 |  | R
2024-01-23 00:00:00 | ATM for Cash A/C | Transfer |  | 200 |  | R
2024-01-26 00:00:00 | [NAME] (for sweepstake) | Unallocated | 5 |  |  | R
2024-02-01 00:00:00 | [NAME] (general xps) | Maintenance |  | 100 |  | R
2024-02-03 00:00:00 | [NAME] (insurance settlement) | Catering | 208.14 |  |  | R
2024-02-04 00:00:00 | [NAME] (mileage 110m @.45p) | V&S Xps |  | 49.5 |  | R | *
2024-02-04 00:00:00 | [NAME] (gifts for Mark & Angie) | V&S Xps |  | 42.5 |  | R | *
2024-02-04 00:00:00 | [NAME] (gifts to [NAME], Nick & Jon) | V&S Xps |  | 60 |  | R | *
2024-02-04 00:00:00 | [NAME] (buggy fuel) | Maintenance |  | 37.85 |  | R | *
2024-02-04 00:00:00 | [NAME] (hedge trimmer sharlening) | Maintenance |  | 25 |  | R | *
2024-02-04 00:00:00 | [NAME] (catering items) | Catering |  | 119.62 |  | R | * one debit of £334.47
2024-02-04 00:00:00 | [NAME] (cash account settlement) | Transfer |  | 59.85 |  | R
 | Balance to be carried forward to next season
* * * | Only the cells above print  * * *
 | INCOME
 | Gun Subscriptions | Gun Subs
 | Sold Days | Sold Days
 | Daily Collections from Guns | Gun Collections
 | Sale of Birds | Sale of Birds
 | T O T A L Income
 | EXPENSES
 | Birds | Birds
 | Feed | Feed
 | Cover Crops | Cover Crops
 | Pen Maintenance | Maintenance
 | Insurance | Insurance
 | Volunteer & Sundry Expenses | V&S Xps
 | Beaters | Beaters & P/Ups
 | Catering | Catering
 | T O T A L Expenses