Importing Check Stubs from a CSV File
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:
- A single producer: every check gets the operator and owner you choose.
- A bank account export: each check gets the operator and owner named on its rows. Choose a MinRight record once for each name in the file.
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
- Money: "$", commas, and spaces are ignored, and "(150.00)" is negative. Amounts with more than two decimals are rounded to the cent.
- Dates: forms such as 2025-07-01, 07/01/2025, and Jul 1, 2025 are read, month first unless the first number is over 12. Production Month also accepts 2025-07, 07/2025, and Jul 2025.
- Words: product types, units, and payment methods are read from common statement words, such as "crude" for Oil or "BBLS" for BBL. An unknown product type is saved as Other.
- When the import changes a value or can't read it, the review lists a warning, and the original text is kept in the notes.
- Check totals are added up from the line items. When a row has both Gross Revenue and Net Revenue, the net must add up to within one cent.
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.