Importing bills from a file

Use Import bills to create many bills at once from a file. It replaces the separate payout and ACH uploads. Every account on Bill Pay has it.

Supported files

• CSV or Excel (.xlsx) with one bill per row
• A bank payout sheet
• An OwnerRez payouts export
• A NACHA ACH file (.ach or .txt)

Files can be up to 4 MB. Split a bigger file and upload each part.

Import a file

1. Go to Payments.
2. Click Import bills, beside your bills.
3. Drop a file in the window, or click browse to choose one.

Accountable reads the file and matches each row to a recipient. Then it walks you through a few steps.

Match columns

If a required column isn't clearly matched, you'll see Match columns. Choose the field for each column in your file, or Don't import to leave it out.

Field	Required
Recipient	Yes
Amount	Yes
Invoice number, Invoice date, Due date, Pay date	No
Memo, Property, Market	No
Bank account number, Routing number	No
GL account, Class, Department, Location	No

If your file has no header row, tick My file has no header row.

When the file names a GL account, class, property or other value Accountable doesn't recognize, you'll be asked to pick the right one. You can pick once for all rows with that value.

Details

Set what applies to every bill:

• Pay from: the account the bills are paid from.
• Approvers: who approves the bills. Your last choice is filled in.
• Submit for approval: on by default. Turn it off to save the bills as drafts and submit them from Bill Pay later.
• Pay date for all rows: used when the file has no dates.
• Add coding (optional): a GL account, class, department, location or property for every row.

Review

The review lists every row, problems first. Use Problems, Ready and All to filter.

Each problem has one fix on its row:

Problem	Fix
No recipient	Pick a recipient, or click Add in Recipients.
Looks like a duplicate	Create anyway, or Skip.
Pay date missing or in the past	Set date.
Anything else	Skip the row.

Click Skip all problems to skip every row that still has one. Click Undo on a row to bring it back.

When no problems are left, click Create bills.

Creating bills

Bills are created in the background. You can close the window and come back; the progress is kept.

When it's done, you'll see how many bills were made and whether they're waiting for approval or saved as drafts. If any bills have no approver, click Name approvers.

If some rows failed, click Retry failed, or Download failed rows to fix them and upload again. Click Import another file to start over.

After the import

Imported bills are ordinary bills. They show on the Payments page and go through your approval workflow. See Approval workflows.

Related articles

• Adding a bill
• Paying owners from their statements
• Merging duplicate vendors