JobBag + Weel CSV Upload Process (NEW)

This guide takes you through the process of getting your WEEL transactions into JobBag. We’ll show you what information to enter in WEEL, how to check and prepare your CSV file, import the transactions, create payments, and reconcile the WEEL bank account.

Step 1: Card Holders enter transactions into WEEL

Advise Employees to use the following fields to capture the relevant JobBag information

Account ID is used to record the JobBag Kind Code.

Budget/Subscription is used to record the JobBag Job Number.

Job number and Kind code need to match exactly what is in JobBag

Step 2: Download and Prepare CSV File for Import

Before importing the Weel CSV into JobBag, check:

• Mapping Requirements: Match the Columns in the csv( See below)
• Account ID: Contains the JobBag Kind Code
• Budget/Subscription: Contains the JobBag Job Number
• Overhead jobs: Use Overhead Kinds
• Client jobs: Use Job Cost Kinds
• Team Member: Add descriptions (if applicable)

The CSV is now ready to import into JobBag.

Mapping Requirements

CSV columns should match below screenshot

Use the following columns to provide the JobBag information:

Overhead vs Client Jobs

Make sure you use the correct Kind Code for the type of job:

• Use Overhead Kinds for overhead jobs.
• Use Job Cost Kinds for client jobs.

This ensures the WEEL transactions are posted to the correct JobBag accounts and jobs.

If You Want to Import the Description (If applicable)

If you want to record a transaction Description in JobBag use the Team Member column.

If you want the transaction description to be recorded in JobBag, copy the information from the Description column into the Team Member column before deleting the Description column.

Check Every Transaction

Before importing the file, make sure every transaction has:

• A JobBag Kind Code in the Account ID column.
• A Job Number in the Budget/Subscription column.

Transactions without these details may not import correctly into JobBag.

Remove Custom Columns (If applicable)

If you are using custom fields in Weel you will need to remove from the CSV:

Same examples include

• Description
• Approved By
• Job Number
• Attendees
• Invoice Number

If You Use the WEEL Job Number Custom Field

If you have entered JobBag job numbers into the Job Number field in WEEL:

1. Copy the job numbers from the Job Number column.
2. Paste them into the Budget/Subscription column.
3. Delete the Job Number column.

Step 3: Import the transactions into Jobbag

Go to: Accounts > WEEL > Select Key:CSV > Select File: > Import   

Review Transactions

• Downloaded transactions appear in the WEEL window.
• The Job and Kind columns will show YES if valid, or NO if missing.
• Payments can only be created when both the Has Job and Has Kind field shows YES
• If you need to update or fix a transaction do that back in the csv file and then up load the file again. Repeat this until Has Job and Has Kind field shows YES
• You can Right click > Set columns to configure the Weel Transaction import window

Step 4. Create Payments

Click Create Payments ( Top Right) to initiate processing for valid transactions.

Once payment is created the payment number will appear in the Payment No column

Payments are created using the Weel supplier and can be found in the browse payments window

Step 5. Reconcile the Weel Bank Account

• Go to: Accounts > Bank Reconciliation > Weel Bank            
• Import the bank statement.
• Matched transactions will automatically turn green.