Skip to content

Home Preorder guides Tracking your own preorders in Excel: when do you need a reminder app?

Tracking your own preorders in Excel: when do you need a reminder app?

This guide is for buyers tracking their own preorders: what they ordered, which shop they paid, the deposit already paid, and when they need to pay the balance. A spreadsheet can hold the records, with reminders configured separately. DuePair offers an iPhone workflow for preorder stages and reminders to pay your own balance. Sellers collecting payments from customers need a different type of tool.

Updated October 17, 2026

Short answer: Excel, Numbers, and cloud spreadsheets are excellent for viewing shop names, amounts, expected balance dates, and notes in columns. Alerts usually need separate setup through a calendar, script, or a habit of opening the file. DuePair provides a ready-made Awaiting Deposit, Awaiting Balance, Awaiting Delivery, and Received workflow with reminders on dates you confirm. The two tools can be used together.

Ask what you need most: a flexible overview or a prompt at the right time.

Capability comparison

CapabilityDuePairExcel / spreadsheet
Deposit and balance stagesReady-madeBuild columns and status rules yourself
Reminders to pay your own balanceBuilt in on a confirmed date, subject to iOS notification and Focus settingsRequires a calendar, script, or manual review
Flexible overview and reconciliationCard-based view with deposit and balance amountsStrong free-form columns, filters, and formulas
Home Screen widgetAvailable with ProAvailability depends on the spreadsheet service; it is generally not preorder-stage specific
Lock Screen Live ActivityAvailable with ProDepends on the spreadsheet service, system integrations, and settings
Mobile entryDesigned around preorder cardsLarge sheets can take more work on a phone
Data locationLocal-first, optional private iCloud, no DuePair accountDepends on the file location and service
Setup and maintenanceReady to useBuild a template and update rows plus separate alerts

When Excel is enough

If you have two or three orders, prefer reconciling them on a computer, and do not need push reminders, a spreadsheet can be ideal. It is also strong for custom totals or a list shared with a partner. You do not need to abandon a good spreadsheet just to use a specialized app.

Missed payments are often not a missing cell

  1. A date without a stage: The row has a date, but it does not show whether the next action is payment or delivery follow-up.
  2. The alert drifts away from the row: The shop changes its schedule, the sheet is updated, and the separate calendar event is not.
  3. The file is not opened: Entering a date does not notify you unless the chosen spreadsheet or connected service has been configured to do so.

A spreadsheet can solve all three, but you must define and maintain the rules.

Using both tools together

A common combination is the spreadsheet for flexible overview and DuePair for stages and confirmed-date reminders. If you need only reconciliation, keep the spreadsheet. If you want fewer status columns and separate calendar events, try DuePair.

iOS notification permission and Focus modes also affect DuePair; installing an app does not guarantee every alert. See the balance-payment guide, the preorder checklist, notes, and Notion.

To test the fit, keep your next confirmed balance date in the sheet and create the same date in DuePair. Compare which workflow is easier when the date changes. Free tracks up to 6 non-archived items; Pro is a one-time purchase. Archive an order after receipt when it no longer needs follow-up.

Work through one order

To transfer one order manually from Excel, verify the item, seller, original link, paid deposit, remaining amount and deadline. Leave unannounced dates unconfirmed. Create the matching stage in DuePair, enter verified fields and check reminders separately. Compare the records before proceeding to the next order and keep the original as a source. There is no one-click import or two-way sync. Keep your current tool if its tables, collaboration or custom structure suit you.

Track your next preorder

Available for iPhone. Track up to 6 non-archived items for free; Pro is a one-time purchase.