Wiki

Case Status
Log In

Wiki

 
Commission Payments via CSV
  • RSS Feed

Last modified on 7/15/2014 1:54 PM by User.

Tags:

Commission Payments via CSV

Overview

Printing and sending a listing of invoices included in the current commission check is not only a waste of manpower (required to key the information), but also wastes paper! Here is a plan that will save any factory paper, postage and gain satisfaction from sales agencies by being easier to do business with electronically.

What the Factory Does

  1. Create and mail the check as usual.
  2. Write the invoices, credits and debits to a PDF file - reference the check number.
  3. Write the same information to a CSV file (detailed below) - name the file the same as the check.
  4. Email items 2,3 to the rep.

We recommend the PDF file be similar to the normal printed format. This allows the accounting team at the sales agency to review the data manually when they have questions. It is also recommended that all the details of credits and debits be added to the PDF - even if the transaction does not correspond to an invoice (e.g. some samples).

The CSV file format is very simple:

  • Two columns of data - comma or tab delimited
  • NO NUMBERS MAY HAVE COMMAS! (e.g. $1,000.00 is bad, but $1000.00 is good)
  • The first column contains invoice number
  • The second column contains the amount paid with a dash or parenthesis showing netgative values.
  • We recommend naming the file the same as the check number - to help match the file to the check.

Here is an example (click to see the contents - a spread sheet will show for most users):

Check_178374.csv

What the Agency Does

When the agency receives the emil, the PDF file may be used as normal (printed if necessary). We do recommend adding the entire email to the payment Attachments tab for later reference.

To load the CSV file, follow these steps:

  1. Save the .csv file to your desktop
  2. Create a new payment, keying the check number, check amount.
  3. (Optional, add the entire email to the attachments tab of the payment)
  4. Select "Tools" then "Load CSV":
  5. Select the CSV file from your desktop.
  6. Once the file is loaded, you will see a "Payment CSV Load" window. It is asking how you would like to view the resulting report (we recommend saving to PDF):

    Example

From here, the accounting team should look for amounts paid to ensure the order was paid as expected.