Templates

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

9 more rows

Also included

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

Questions

What is included in the Bookstore: Yarrowdale Park Books template?
5 tables (Orders, Customers, Order lines, Titles and Payments), filled with 142 sample rows so every view opens with realistic data.
Is the Bookstore: Yarrowdale Park Books template free?
Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
Can I change the template after I use it?
Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.