Payment reconciliation worksheet: purpose and instructions
Match expected and received entries by unique reference and flag discrepancies. Calculate locally and copy the result; inputs are not saved automatically.
How to use
Enter the values and check their units and conditions. Paste data in the field order, review the result, then copy or print. Frequently asked questions
Is data saved or uploaded? Inputs are processed in browser memory on this page and cleared on refresh or departure.
Related tools
Shift time worksheet — Calculate working time from start, finish and break minutes, including overnight shifts.Duplicate table row checker — Find exactly matching TSV rows and retain their original line numbers.Document Date Inventory — Sort recorded dates to help check source documents; this does not determine validity.Item quantity aggregator — Paste simple TSV to sum matching items and units and trace source lines.Required fields checker — Paste simple TSV with headers, choose required columns, and copy a report of blank fields by original line.Group availability intersection finder — Merge each person's same-day availability and find shared intervals plus possible start ranges that fit the meeting length.Serial Number Gap Checker — Check one number per line against a fixed-width range to find gaps, duplicates, out-of-range entries and format errors.Inventory reconciliation — Check the book and actual quantity according to the product number, and list the shortages, surpluses and items to be reviewed.Booking conflict checker — Check overlapping time periods for appointments with the same resource and on the same day, and retain the original sequence numbers for manual coordination.Time zone meeting planner — Use Taipei time to compare with Tokyo, London and Los Angeles to check the complete date and daylight saving time.Working days and deadlines — Calculate the interval days or delivery date according to the selected work rules.Amount and date conversion — The amount, Republic of China and AD dates in Chinese capital letters, copy them as you like.URL QR code generator — Check the complete public URL, generate a black and white QR Code in the browser and download the PNG.List sorting and deduplication — Organize multi-line lists, items or codes and remove blank lines and duplicate items.Double list comparison — Check the scheduled and actual lists, listing items that are only in A, both parties, and only in B.Text version differences — Compare the two versions of the notice or process text line by line, and list the identical, new and deleted content.Batch file name planner — Paste the file name, arrange the prefix, serial number and file extension, and take away the complete comparison table.Meeting agenda schedule — Fill in the start time and topic minutes, and list the start and end time of each item and the complete agenda.Random grouper — Paste the list of participants, specify the number of groups, and arrange random groups with a balanced number of people.Countdown to work and meetings — Set a period of time, start, pause and continue the countdown, and clearly grasp the time.Duty roster — Arrange the rotation according to the date, week and personnel order, and check the complete arrangement and the number of times per person.StarShare cross-device file transfer — Transfer files, text and links between mobile phones and computers without installation or login.