Import a Spreadsheet for a Draw Request

Guide Steps

If you have the option to create draw requests, click Actions > Create New Voucher Draw Request

1

Click the Import button to import a spreadsheet

2

Click the OK button – your spreadsheet can only have one sheet on it and no custom formulas

3

Click the Choose File button and select your desired spreadsheet, then click the Import button

4

Here is where you see all the data in the columns, each column you can select what to import that into. Cost Code and Amount are required to be selected for your columns. There are also options for Joint Vendor, Notes, or Invoice number as well if you track that on your spreadsheet

Once done selecting the columns, you can click Accept to import that data

5

Once that data is imported you can still edit/add/delete anything in the voucher/draw screen

6