AI Matrx Logo

Bookstore

Yarrowdale Park Books · Bookstore · Duluth, MN

Isolde Novotny is the manager at Yarrowdale Park Books, an independent bookstore in Duluth, and she uses this to bill every school, library, book club and special order and to chase the balances that are still unpaid.

RetailBillingLinked tables6 tables · 7 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 document · 1 agent
Use this template

Billing board

Orders
Invoiced7
ORD-26-202Larkin Ridge ElementaryClassroom set
ORD-26-204Saint Brennan Academy LibraryClassroom set
ORD-26-210Lakewalk Branch LibraryShelf restock
ORD-26-213Thursday Night Page TurnersBook club order
ORD-26-219Northbend Dental LoungeShelf restock
2 more
Partly paid3
ORD-26-206Cedar Pass Middle SchoolClassroom set
ORD-26-223Birchlight InnShelf restock
ORD-26-228Perdita LindgrenovaSpecial order
Paid15
ORD-26-201Larkin Ridge ElementaryClassroom set
ORD-26-207Tallgrass County LibrarySpecial order
ORD-26-211Thursday Night Page TurnersBook club order
ORD-26-212Thursday Night Page TurnersBook club order
ORD-26-214Harborview Mystery CircleBook club order
10 more
Overdue8
ORD-26-203Saint Brennan Academy LibraryClassroom set
ORD-26-205Cedar Pass Middle SchoolClassroom set
ORD-26-208Tallgrass County LibraryShelf restock
ORD-26-209Lakewalk Branch LibrarySpecial order
ORD-26-215Harborview Mystery CircleBook club order
3 more

Tables

Orders

33 sample rows · 15 columns

Every order billed: what it is for, who owes it, when payment is due and what is still unpaid.

Order numberCustomerOrder kindWhat it is forPlacedPayment dueStatus
ORD-26-213Thursday Night Page TurnersBook club orderHistorical novel pickOct 18, 2026Oct 18, 2026Invoiced
ORD-26-230Imogen Falkirk-DubeSpecial orderAtlas and field guidesOct 18, 2026Oct 18, 2026Invoiced
ORD-26-221Twelve Pines Coffee RoastersShelf restockCafe cookbooks and field guidesOct 14, 2026Oct 29, 2026Invoiced
ORD-26-210Lakewalk Branch LibraryShelf restockFront table staff picksOct 13, 2026Oct 28, 2026Invoiced
ORD-26-228Perdita LindgrenovaSpecial orderImported art book on depositOct 12, 2026Oct 12, 2026Partly paid
ORD-26-206Cedar Pass Middle SchoolClassroom setLibrary cart refreshOct 10, 2026Nov 9, 2026Partly paid
ORD-26-219Northbend Dental LoungeShelf restockChildren's cornerOct 9, 2026Oct 24, 2026Invoiced
ORD-26-227Dmitri KesslingGift orderWedding gift cookbooksOct 8, 2026Oct 8, 2026Paid
ORD-26-223Birchlight InnShelf restockGuest library before leaf seasonOct 7, 2026Nov 6, 2026Partly paid
ORD-26-204Saint Brennan Academy LibraryClassroom setFourth-grade library cartOct 6, 2026Nov 5, 2026Invoiced
ORD-26-217Sunday Sonnets SocietyBook club orderPoetry collection pickOct 4, 2026Oct 4, 2026Paid
ORD-26-226Oksana Pellegrin-HaasSpecial orderSigned copy from a dealerOct 3, 2026Oct 3, 2026Paid

21 more rows

Customers

20 sample rows · 12 columns

The schools, libraries, clubs, businesses and readers who buy on account.

CustomerAccount typeBilling contactPhoneEmailBilling termsAccount since
Ansel Okonkwo-BrandtIndividualAnsel Okonkwo-Brandt(218) 555-0130ansel.okonkwobrandt@yarrowdaleparkbookshop.comDue on receiptFeb 10, 2026
Birchlight InnBusinessCordelia Ravenscroft-Ma(218) 555-0122cordelia.ravenscroftma@yarrowdaleparkbookshop.comNet 30Oct 14, 2023
Cedar Pass Middle SchoolSchoolOttilie Brandvik-Sutter(218) 555-0113ottilie.brandviksutter@yarrowdaleparkbookshop.comNet 30Feb 11, 2024
Dmitri KesslingIndividualDmitri Kessling(218) 555-0126dmitri.kessling@yarrowdaleparkbookshop.comDue on receiptMay 1, 2024
Fernside Family ClinicBusinessTarquin Abara(218) 555-0123tarquin.abara@yarrowdaleparkbookshop.comNet 15May 6, 2025
Harborview Mystery CircleBook clubTiberius Oosterhaus(218) 555-0117tiberius.oosterhaus@yarrowdaleparkbookshop.comDue on receiptFeb 5, 2025
Imogen Falkirk-DubeIndividualImogen Falkirk-Dube(218) 555-0129imogen.falkirkdube@yarrowdaleparkbookshop.comDue on receiptDec 22, 2025
Knotted Thread Book ClubBook clubNuala Tregarthen-Vance(218) 555-0118nuala.tregarthenvance@yarrowdaleparkbookshop.comDue on receiptSep 3, 2025
Lakewalk Branch LibraryLibraryOdalys Mckittrick(218) 555-0115odalys.mckittrick@yarrowdaleparkbookshop.comNet 15Jan 2, 2022
Larkin Ridge ElementarySchoolMarguerite Delacroix-Voss(218) 555-0111marguerite.delacroixvoss@yarrowdaleparkbookshop.comNet 30Sep 9, 2022
Northbend Dental LoungeBusinessLysander Quennell(218) 555-0120lysander.quennell@yarrowdaleparkbookshop.comNet 15Jun 30, 2024
Oksana Pellegrin-HaasIndividualOksana Pellegrin-Haas(218) 555-0125oksana.pellegrinhaas@yarrowdaleparkbookshop.comDue on receiptMay 17, 2023

8 more rows

Order lines

52 sample rows · 5 columns

The titles and copy counts that make up each order.

Order lineOrderTitleCopiesLine amount
ORD-26-201: Primer for Young BirdersORD-26-201Primer for Young Birders16$207.84
ORD-26-201: Salt Road SummerORD-26-201Salt Road Summer26$285.74
ORD-26-202: Primer for Young BirdersORD-26-202Primer for Young Birders15$194.85
ORD-26-202: The Map-Makers' ClubORD-26-202The Map-Makers' Club26$259.74
ORD-26-203: Pip and the Lantern MothORD-26-203Pip and the Lantern Moth26$233.74
ORD-26-203: The Map-Makers' ClubORD-26-203The Map-Makers' Club11$109.89
ORD-26-204: The Very Patient HeronORD-26-204The Very Patient Heron19$151.81
ORD-26-204: Primer for Young BirdersORD-26-204Primer for Young Birders14$181.86
ORD-26-205: Pip and the Lantern MothORD-26-205Pip and the Lantern Moth28$251.72
ORD-26-205: The Map-Makers' ClubORD-26-205The Map-Makers' Club24$239.76
ORD-26-206: The Very Patient HeronORD-26-206The Very Patient Heron30$239.70
ORD-26-207: A Winter at Birchwater LightORD-26-207A Winter at Birchwater Light2$33.90

40 more rows

Titles

16 sample rows · 3 columns

The titles the shop sells on account, with list price.

TitleSectionList price
A Winter at Birchwater LightFiction$16.95
Field Notes from the North ShoreNonfiction$24.95
Fog Over the Ore DocksMystery$14.99
Light on the Inland SeaArt$45
Locked Rooms of Harbor StreetMystery$15.95
Pip and the Lantern MothChildren$8.99
Primer for Young BirdersChildren$12.99
Salt Road SummerYoung adult$10.99
Steel, Ice and Iron Range MenNonfiction$26
Ten Thousand Lakes, One SpoonCookbooks$29.95
The Ledger of Small MerciesFiction$17.99
The Map-Makers' ClubYoung adult$9.99

4 more rows

Payments

21 sample rows · 5 columns

Each payment received against an order.

Payment numberOrderReceivedAmountPaid by
PMT-26-303ORD-26-206Oct 12, 2026$120Check
PMT-26-318ORD-26-228Oct 12, 2026$41Card
PMT-26-314ORD-26-223Oct 10, 2026$36Check
PMT-26-317ORD-26-227Oct 8, 2026$154Card
PMT-26-310ORD-26-217Oct 5, 2026$168Card
PMT-26-316ORD-26-226Oct 3, 2026$33.90Card
PMT-26-315ORD-26-225Oct 2, 2026$83.80Card
PMT-26-319ORD-26-229Sep 29, 2026$23.97Card
PMT-26-309ORD-26-216Sep 22, 2026$63Card
PMT-26-313ORD-26-222Sep 20, 2026$29.95Bank transfer
PMT-26-308ORD-26-216Sep 19, 2026$63Card
PMT-26-302ORD-26-205Sep 17, 2026$197Check

9 more rows

Also included

  • Payment reminderDocumentThe note sent to a customer whose invoice is past due.
  • Overdue orders each MondayDigest

Related templates