Others

How to Track Payments and Supply Pickup in Microsoft Forms Responses

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs a method to track whether respondents have completed payments and picked up supplies after submitting a Microsoft Form.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Managing post-registration tasks, such as tracking order payments or physical supply pickups, based on submitted form data.
Observed behavior: Microsoft Forms does not provide native status tracking or payment fields, requiring users to track this data externally using Excel or Power Automate.

Before you start

Determine whether your form is still actively collecting responses (live) or if registration is complete, as this will dictate whether you should use a simple Excel export or a Power Automate flow.

Solution 1Recommended

Track Statuses in Exported Excel Workbooks

Ideal for completed registration lists where no new responses are actively being submitted.

When a form has finished collecting responses, you can export the data to Excel and manually track statuses using custom columns. Be aware that if the form is still live, manually added custom columns may not persist correctly or could become misaligned when the workbook updates with new responses.

Open Forms results in Excel

Navigate to the Responses tab in your Microsoft Forms dashboard and click the 'Open in Excel' button to download your response data.

Add tracking columns

In the downloaded Excel file, add new column headers next to the imported data, such as 'Payment Status' and 'Supply Pickup'.

Insert checkboxes for tracking

Go to the Developer tab, click 'Insert', select the Checkbox form control, and place it in your new status cells to easily check off completed items.

Live Updates Warning: If your form is still collecting responses, custom columns in the live synced workbook might get misaligned. For ongoing live forms, use the Power Automate method instead.

Solution 2

Use Power Automate for Ongoing Updates

Best for live forms where responses are continuously being submitted, ensuring custom tracking columns remain reliable and are not overwritten.

Free Microsoft Office alternative

Manage Exported Form Data Effortlessly with WPS Office

If you are working with exported Microsoft Forms data, WPS Spreadsheet is a free, lightweight, and easy-to-use alternative to Microsoft Excel. It allows you to organize submissions, format tracking tables, and insert status checkboxes seamlessly, all within a familiar interface.

1. Download and install WPS Office: Get the free WPS Office suite from the official website and install it on your computer.
2. Open your form data: Launch WPS Spreadsheet and open the .xlsx file you downloaded from Microsoft Forms.
3. Add tracking tools: Create new columns and use the Insert tab to add form controls like checkboxes for efficient payment and pickup tracking.

Free and lightweight alternative to expensive Office subscriptionsFully compatible with Microsoft Excel (.xlsx) files exported from FormsEasily insert checkboxes and data validation to track response statusesFamiliar user interface ensuring a seamless migration with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why do my custom columns disappear when new Forms responses sync to Excel?

When a live Microsoft Form syncs new responses to an Excel workbook, it dynamically updates the underlying data table structure. This process can overwrite, hide, or misalign any custom columns you have manually added alongside the synced form data.

Can I collect payments directly inside Microsoft Forms?

No, Microsoft Forms does not currently support native payment gateways or built-in payment collection fields. You must collect payments via an external platform and track the status manually or through an automated workflow.

How can I safely track live form responses without losing data?

The most reliable method for live forms is to use Microsoft Power Automate. By setting up a flow to copy new form submissions into a completely separate Excel table or SharePoint list, you can safely maintain custom tracking columns without interference from the native Forms sync mechanism.

Office Quick Solutions