If you have your check stub detail in a CSV file (a spreadsheet you keep, a download from an operator's website, or an export from your bank account), the import wizard can bring many checks into MinRight at once. Each row of the file is one line item, and a new check starts each time the check number changes from the row above.

On the Royalty Payments page, click Import.

Step 1: Select the File

Click Select CSV File and choose the file. MinRight shows how many rows and columns it found and a preview of the first 5 rows. A file can have up to 100,000 rows and 50 MB.

Step 2: Map the Columns

MinRight maps the columns it recognizes (Auto-Map Columns does it again). For each column, choose its Target Field, or -- Skip -- to ignore it. Check Number, Check Date, Product Type, and Gross or Net Revenue must be mapped.

Step 3: Match the Records

First, say where the file is from:

Then match the file's well names or API numbers to your wells, and look over the Check Grouping Preview to make sure the rows group into the right checks.

Step 4: Review and Import

MinRight checks the whole file without saving anything and lists the checks it will create, with any warnings and errors. If any row has an error, nothing is imported: fix the file and click Check Again. When the review is clean, click Import to save every check.

A check whose number MinRight already has from the same operator is left out and listed under Already in MinRight, so importing the same file twice doesn't add its checks twice.

After an import, Import Another starts over, and View Royalty Payments opens the list.

How Values Are Read

Tip

Click Create Backup Now on the Backup & Data tab in Settings before a big import, so you can go back if the file wasn't what you expected. See How to Set Up Backups.