From b1c11ecfd4f9b6afffcfadc781de6c62972c1bac Mon Sep 17 00:00:00 2001 From: Zach DeCook Date: Fri, 11 Sep 2026 20:44:47 -0400 Subject: hledger: Add scripts and rules --- macatawa-checking.csv.rules | 383 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 383 insertions(+) create mode 100644 macatawa-checking.csv.rules (limited to 'macatawa-checking.csv.rules') diff --git a/macatawa-checking.csv.rules b/macatawa-checking.csv.rules new file mode 100644 index 0000000..80ae365 --- /dev/null +++ b/macatawa-checking.csv.rules @@ -0,0 +1,383 @@ +# skip header +skip 3 +fields date, account, description, checkno, category, memo, credit, amount + +date-format %-m/%-d/%Y + +account1 assets:macatawa:checking + +if +PREAUTHORIZED DEBIT FRANKLIN +PREAUTHORIZED DEBIT FRK + account2 expenses:rothIRA + +if +MUSEUM OF THE BIBLE +OHIO TURNPIKE PLAZA +DC PARK*METER +METER MULTI 202-673-6813 DC +BAD ASS COFFEE +CHARLEYS PHILLY STEAKS WASHINGTON DC +RANGOS RESTAURANT 703-2005516 VA +MAZAROITALIANRESTAU ARLINGTON VA +SPYMUSEUM WASHINGTON DC +BASIC BURGER - LEN WASHINGTON DC +WHOLEFDS ARL 100 2700 W ARLINGTON VA +HARVEYS Falls Church VA +MIDNIGHTREATS - ARL Arlington VA +STARBUCKS 75941 4201708 VERONA PA +ROY ROGERS RESTAURANT 4 HAGERSTOWN MD +SHAKE SHACK Arlington VA +AIRBNB.COM +YOUR COUNTRY STORE HAGERSTOWN MD +HAMMONDSPORT KWIK FILL HAMMONDSPORT NY +CROOKED LAKE ICE CR Hammondsport NY +Love's #0863 Inside MADISON OH +PARK PHARMACY OF HAMMON HAMMONDSPORT NY +OAK HILL BULK FOODS INC PENN YAN NY +CVS/PHARMACY #05 05009- PENN YAN NY +CVS STORE#05-S00 226 LAKE ST PENN YAN NY +PILOT #0002 AUSTINBURG OH +PILOT_00002 AUSTINBURG OH +AVIS.COM PREPAY XXXXXX7900 VA +AIRBNB.COM +Bill Paid-ANGELA LEOPOLD +WIENERLICIOUS MACKINAW CITY MI +SHELL SERVICE STATION MACKINAW CITY MI +MACKINAW FAMILY MARKET MACKINAW CITY MI +THE PARK STORE MACKINAW CITY MI +GREAT TURTLE BREWER Mackinac Isla MI +SHEPLERS MACKINAC ISLAN MACKINAW CITY MI +BENJAMIN OF MACKINAC IS MACKINAC ISLA MI +DESTINATION MACKINA 198-94296783 MI +MACKINAW MILL CREEK CAM MACKINAW CITY MI +JOHAN'S PASTRY SHOP INC PETOSKEY MI +CORMACKS DELI PETOSKEY MI +KENSINGTON COURT ANN ARBOR MI +KENSINGTON HOTEL ANN ARBOR MI +CASA TINA 727-7349226 FL +SAND&SKY SHOPPE ST2091 CLEARWATER FL +AVIS RENT-A-CAR CLEARWATER FL +ALLEGNT BUYONBOARD LAS VEGAS NV +PUBLIX #1320 SEMINOLE FL +SPROUTS FARMERS MARKET SEMINOLE FL +JOHNS PASS PARKING parkmobilecom FL +SUNSHINE SCENIC TO WWW.BOATTOURS FL +BEACH COUTURE DUNEDIN FL +CUMBERLAND CITGO SEMINOLE FL +SALVADOR DALI MUSEUM IN SAINT PETERSB FL +METAPAY.Benjamin J Isy pay.fb.com CA +WAL-MART #3013 7500 66TH ST N PINELLAS +ALLEGNT AIR,I3M 702-5058888 NV +A2 PCI PARKING 82 RAMP IRVINE CA +THOMPSON & CO YPSILANTI MI +EL MOLCAJETE MEXIC AN R DELANO +JOHNNY ROCKETS MIN NESO BLOOMINGT MN +MICKEY'S DINE R SAINT PAU MN +BIG FAT BACON SAINT PAU MN +MALL OF AMERICA BLOOMINGT MN +BUNKIN #359446 * BLOOMINGT MN +MMs Mall of Americ a +LEGO MALL OF AMERI CA +DUNKIN #359446 BLOOMINGT MN +MSP AIRP COMO PK E SSEN ST PAUL MN +BATH & BODY WORKS 3810 BLOOMINGT MN +FRENCH CREPERIE MINNEAPOL MN +MT HIAW TVM LNBERG TER MINNEAPOL MN + account2 expenses:special + +if +JOEZANOS PIZZA +BIGGBY +MR YOU CHINESE FOOD +TACO BELL +OLIVE GARDEN +RAISING CANES +LA CREME CAFE +THE FARMHOUSE ZEELAND +WINDMILL ISLAND +UCCELLOS RISTORANTE +AUNTIE ANNES +DORADOS MEXICAN GRILL +ARBYS +HOG WILD BBQ +CRUMBL +DEBOERS BAKKERIJ +STOVETOP COFFEE ROA +THE FAT BURRITO +CULVERS +MCDONALD'S +CAPTAIN SUNDAE +VITALES PIZZA +STARBUCKS +MASSAGE MY SPA GRANDVILLE +PIETROS ITALIAN +CORELIFE +CRANE'S PIE PANTRY +LEWIS FARM MARKET NEW ERA MI +LEWIS ADVENTURE FAR NEW ERA MI +BOATWERKS RESTAURANT +TAMMI SALON +CRUST 54 +THE CITY DELICATESSEN +UCCELLOS RESTAURANT +WILDROASTCOFFEECO.COM +H.T. NAILS HOLLAND +QDOBA +CANCUN MEXICAN GRILL +HUNGRY HOWIES +RUSSS RESTAURANT +RUSS'S RESTAURANT +RUSS RESTAURANT +CRANES IN THE CITY +DAIRY QUEEN +QCW - WAVERLY +APPLEBEE'S +APPLEBEES +BECHLER'S FUN FOODS Tecumseh MI +NIKKI?S CONCESSIONS Allegan +CONCESSIONS Allegan MI +SATTLER'S CONCESSIO Allegan +TAQUERIA DON CHEPE LLC NILES MI +GAZELLA'S FINER FOODS CARSON CITY MI +OSMOWS MEDITERRANEAN GRANDVILLE +ZINGERMANS COFFEE +GEORGE'S SENATE CONEY +CITY OF SAUGATUCK OVAL +CONDADO TACOS +THE PAISLEY GRILLE GRAND HAVEN MI +CHICK-FIL-A +BIG APPLE BAGELS +EL RANCHO +HAMILTON FOOD CTR +FAMILY FARE +RAINBOW GRILL GRANDVILLE +BURGER KING +FOXTAIL COFFEE +OASIS HOT TUB GARDE +BEECHWOOD INN +D&W FRESH MARKET +BOWERMAN'S ON 8TH +AIRBORNE BURRITOS +DRYE'S CONCESSIONS +PI2GO GEORGETOWN TO MI +S&S CONFECTIONS +HARDIN`S CONCESSIONS +GOLDEN 28 +HAMILTON FOOD CT +NEW HOLLAND BREWING +ZOUP EATERY +THE GOOD EARTH CAFE +RUSS RESTAURAN +LICARIS SICILIAN PIZZA +POTBELLY +RED ROBIN +SLUGGO'S PIZZA +PANERA BREAD +METZGER'S +THE WOODEN SHOE +RISE PIES +JAMES STREET INN +STEAK-N-SHAKE#0302 +DD SIDE ALES +TELL-TALESTRATTORIA +THE BEVERAGE BOUTIQ +THE PARLOR BY HOUSE +DRIP ZEELAND MI +THOMPSON & CO YPSILANTI MI +PEACHWAVE +HARDIN +Boatwerks Water +CELEBRATION CINEMA +KRISPY KREME 0346 GRAND RAP MI + account2 expenses:dining + +if +Nelis Dutch Village +BARNES & NOBLE +JCPENNEY +SQUISHABLE +LEGO Store +SEPHORA +KOHL'S +WWW.LILYGO.CC +VISA INTERNATIONAL SERVICE ASSESSMENT +SHIFT 140-44417214 MI +MNRD-HOLLAND +BURLINGTON STORES +Gateway Mission Thrift +NOT SO SHABBY +IKEA +The Grant Me Hope Thrif +MICHAELS STORES +HOBBYLOBBY +OUT OF THE BOX +ENGEDI SALON +LOWE'S +ANTIQUES & VINTAGE +THE SKIN CLIQUE SHOP.SKINCLIQ SC +TARGET +CLAIRE'S +JONKERS GARDEN +H&M +HEINEN DELFTS BLAU +ANTHROPOLOGIE +MENARDS +VERIZON WRLS +HRM'S GATEWAY CENTER +LOWES +DIEMER'S FARM +LEUTZINGER FARMS +ROBINSON.S POPCORN +CAPTAIN CUSTARD +LINKLAND, LLC Holland MI +OUTPOST OF HOLLAND +JAKE'S FIREWORKS +WHT HS BLK MKT +OLD NAVY +SIERRA #4188 +WALGREENS +CABELAS +KID TO KID +HRM'S GATEWAY CENTER +ULTA +HOMEGOODS +MENARDS +BARGAIN LANE +Fjallraven Ann Arbor MI +THE FOUND COTTAGE +CVS/PHARMACY +EAGLES NEST +MOM & BABY AGAIN +FAMILY CENTRAL +SILVER FOX II JEWELRY +WAL WAL-MART SUPER +MAURICE'S +Francescas +OLD SCHOOL SODA CO +TORRID +JOANN STORES +HOPE'S OUTLET +KENDRA SCOTT +FARM & FLEET +JEAN MARIES +WALMART.COM +ESTELLA ROSE FASH +Withdrawal at ATM +THE BRIDGE Holland MI +SENARAH SALFORD GB +Withdrawal
Withdrawal +AMAZON MKTPL +Amazon +Drop.com +Defender Razor +DEFENDER RAZO +GameStop +CROWDSUPPLY HPI +ATM Withdrawal +PURCHASE MERCHANT PURCHASE TERMINAL 15410196 BEST BUY +Nintendo +IFIXIT + account2 expenses:shopping + +if +HARVEST HEALTH FOODS +ALDI +MEIJER +EARL'S MEATS +NATURE'S MARKET +TRADER JOE +HORROCKS FARM MKT +COSTCO +eBay +PINE STORE + account2 expenses:shopping + +if +MARATHON +SPEEDWAY +TULIP CITY TRUCK STOP +BP#2140300KUMAR PETROLEU +SUNOCO +M & A MART LLC 3700 CHICAGO DR +BP#8305765FILLMORE +PILOT # 1021 HOLLAND +BP#9260936COLONIAL BP +EXXON +PILOT # 1021 +PILOT 1021 +Love's #0742 +Love's #0785 +SHELL OIL +VRIESLAND COUNTRY STORE 6420 BYRON ROAD +HUDSONVILLE AGO +OASIS MOBIL MART +WINDMILL MART HOLLAND MI +TULIP CITY TRUC +Allegan County Ag Gate + account2 expenses:gas + +if +Bill Paid-AARON ISYK +Bill Paid-HOLLAND BOARD +Bill Paid-SEMCO ENERGY GAS +Bill Paid-KENSINGTON I CONDO +WITHDRAWAL COMCAST-XFINITY +Bill Paid-JARED DECOOK +HOLLAND BOARD UTIL +WITHDRAWAL HOLLAND BPW +WITHDRAWAL COMCAST +Soprani Ca Telecom +SOPRANI.CA TELECOM +SOPRANI.CA TELE +Linode Akamai +LINODE . AKAMAI +PURISM +OPENCOLLECTIV +LINODE +SR.HT +Sourcehut +Squarespace + account2 expenses:utilities + +if +THE MUSTARD SEED +WITHDRAWAL Immanuel Church +Bill Paid-BANGLA MINISTRIES +BANGLA MINISTRIES +BANGLA MINIST + account2 expenses:charity + +if +GARY'S AUTOMOTIVE +HOLLANDHOSPITAL +WITHDRAWAL FARM BUREAU MI +UMH-WEST WYOMING MI +JONATHAN STEVENS MAT +OBGYNASSOCHOLLAND +STUDIO SEVENTEEN +HOLLAND COMMUNITY HOSP +WEST MICHIGAN ORAL +THOMAS C. PHARES D.D.S +MICHIGAN DMV +HOLLAND ACE HARDWARE +Supercuts +O'REILLY + account2 expenses:health + +if WITHDRAWAL PENNYMAC + account2 expenses:mortgage + +if +Deposit Transfer From Share 00 +Withdrawal Transfer To Share 00 + account2 assets:lmcu:savings + + +if +Withdrawal Courtesy Pay fee +Service Charge + account2 expenses:fees + +if Deposit Dividend + account2 income:interest -- cgit 1.4.1