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 5, 2026Oct 5, 2026Invoiced
ORD-26-230Imogen Falkirk-DubeSpecial orderAtlas and field guidesOct 5, 2026Oct 5, 2026Invoiced
ORD-26-221Twelve Pines Coffee RoastersShelf restockCafe cookbooks and field guidesOct 1, 2026Oct 16, 2026Invoiced
ORD-26-210Lakewalk Branch LibraryShelf restockFront table staff picksSep 30, 2026Oct 15, 2026Invoiced
ORD-26-228Perdita LindgrenovaSpecial orderImported art book on depositSep 29, 2026Sep 29, 2026Partly paid
ORD-26-206Cedar Pass Middle SchoolClassroom setLibrary cart refreshSep 27, 2026Oct 27, 2026Partly paid
ORD-26-219Northbend Dental LoungeShelf restockChildren's cornerSep 26, 2026Oct 11, 2026Invoiced
ORD-26-227Dmitri KesslingGift orderWedding gift cookbooksSep 25, 2026Sep 25, 2026Paid
ORD-26-223Birchlight InnShelf restockGuest library before leaf seasonSep 24, 2026Oct 24, 2026Partly paid
ORD-26-204Saint Brennan Academy LibraryClassroom setFourth-grade library cartSep 23, 2026Oct 23, 2026Invoiced
ORD-26-217Sunday Sonnets SocietyBook club orderPoetry collection pickSep 21, 2026Sep 21, 2026Paid
ORD-26-226Oksana Pellegrin-HaasSpecial orderSigned copy from a dealerSep 20, 2026Sep 20, 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 receiptJan 28, 2026
Birchlight InnBusinessCordelia Ravenscroft-Ma(218) 555-0122cordelia.ravenscroftma@yarrowdaleparkbookshop.comNet 30Oct 1, 2023
Cedar Pass Middle SchoolSchoolOttilie Brandvik-Sutter(218) 555-0113ottilie.brandviksutter@yarrowdaleparkbookshop.comNet 30Jan 29, 2024
Dmitri KesslingIndividualDmitri Kessling(218) 555-0126dmitri.kessling@yarrowdaleparkbookshop.comDue on receiptApr 18, 2024
Fernside Family ClinicBusinessTarquin Abara(218) 555-0123tarquin.abara@yarrowdaleparkbookshop.comNet 15Apr 23, 2025
Harborview Mystery CircleBook clubTiberius Oosterhaus(218) 555-0117tiberius.oosterhaus@yarrowdaleparkbookshop.comDue on receiptJan 23, 2025
Imogen Falkirk-DubeIndividualImogen Falkirk-Dube(218) 555-0129imogen.falkirkdube@yarrowdaleparkbookshop.comDue on receiptDec 9, 2025
Knotted Thread Book ClubBook clubNuala Tregarthen-Vance(218) 555-0118nuala.tregarthenvance@yarrowdaleparkbookshop.comDue on receiptAug 21, 2025
Lakewalk Branch LibraryLibraryOdalys Mckittrick(218) 555-0115odalys.mckittrick@yarrowdaleparkbookshop.comNet 15Dec 20, 2021
Larkin Ridge ElementarySchoolMarguerite Delacroix-Voss(218) 555-0111marguerite.delacroixvoss@yarrowdaleparkbookshop.comNet 30Aug 27, 2022
Northbend Dental LoungeBusinessLysander Quennell(218) 555-0120lysander.quennell@yarrowdaleparkbookshop.comNet 15Jun 17, 2024
Oksana Pellegrin-HaasIndividualOksana Pellegrin-Haas(218) 555-0125oksana.pellegrinhaas@yarrowdaleparkbookshop.comDue on receiptMay 4, 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-206Sep 29, 2026$120Check
PMT-26-318ORD-26-228Sep 29, 2026$41Card
PMT-26-314ORD-26-223Sep 27, 2026$36Check
PMT-26-317ORD-26-227Sep 25, 2026$154Card
PMT-26-310ORD-26-217Sep 22, 2026$168Card
PMT-26-316ORD-26-226Sep 20, 2026$33.90Card
PMT-26-315ORD-26-225Sep 19, 2026$83.80Card
PMT-26-319ORD-26-229Sep 16, 2026$23.97Card
PMT-26-309ORD-26-216Sep 9, 2026$63Card
PMT-26-313ORD-26-222Sep 7, 2026$29.95Bank transfer
PMT-26-308ORD-26-216Sep 6, 2026$63Card
PMT-26-302ORD-26-205Sep 4, 2026$197Check

9 more rows

Forms and booking

Open an account

Form
Open an accountThe form a school, library or book club fills in to buy on account.
What is the name of your school, club or business? *
Which of these describes you best? *SchoolLibraryBook clubBusinessIndividual
Who should we send invoices to?
What number can we reach you on?
Which email should invoices go to?
How soon do you usually pay an invoice? *Due on receiptNet 15Net 30Schools and libraries often pick 30 days.
Request an account

Dashboards

Billing and collections

Orders
Orders by status
  • Paid15
  • Invoiced7
  • Overdue8
  • Partly paid3
Still owed by order kind
  • Classroom set$1,546.07
  • Special order$187.90
  • Shelf restock$1,848.80
  • Book club order$426.70
  • Gift order$0
Orders placed by week
  • Jun 28, 20261
  • Jul 12, 20261
  • Jul 19, 20261
  • Aug 2, 20263
  • Aug 9, 20262
  • Aug 16, 20262
  • Aug 23, 20262
  • Aug 30, 20262

Also included

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

Related templates