The Remittance file must be in the csv (Comma Seperated Value) text format.
It's basically a simple text file where numbers and text are separated by commas and rows end with a Return. (Carriage Return).
But if you get given a MS Office or Open Office spreadsheet that's fine. Save the spreadsheet as a CSV.
So your customers, say a Practice Manager, could email you a remittance list in a spreadsheet.
Other organisations such as IDH have their own format which the Remitter can accept. The Remitter is flexible and will allow you to choose the columns you want, and ignore the ones you don't want.
Here's a typical remittance file
myRemitTest.csv
INV196590,06/29/2014,31.34
INV196591,06/29/2014,16.62
INV196602,06/29/2014,23.51
INV196631,07/03/2014,16.62
INV196632,07/03/2014,29.92
If we imported the above, the remitter would ignore the taxdate column.
We only need the Invoice reference, and optionally the remittance amount, but other columns would be ignored.
Here'a real but minimal remittance file...
INV196590
INV196591
INV196602
You could copy the above invoice list and paste it into a text file saved as MyTest.csv and the Remitter could read it.
Of course if the invoice references arn't valid the Remitter will report that.
If we don't import the remittance amount the Remitter will use the Invoice Total and may complain if the amounts are greater than the Invoice Balance. But then you could click 'Tools - Un-allocate all remitted invoices' and it would then work.
Here's another minimalist remittance file but with remittance amounts provided.
INV196590,31.34
INV196591,16.62
INV196602,23.51
INV196631,16.62
INV196632,29.92
You can have column headers or not, and also other rows with rubbish in. The Remitter will sort these out for you, within reason.
It doesn't matter which columns your data are in, but it's slightly quicker if the InvRef is in column 1 and remit amount (if required) in column 2.
INVOICENO,DATE,AMT,NAME
INV196829,07/13/2014,16.62,Mr C Austin(484)
INV196849,07/17/2014,31.34,Mr C Austin(484)
MARMITE,TASTES,0.00,SALTY(484)
INV198878,01/08/2015,31.34,Mr F Turner(613)
INV198885,01/09/2015,83.6,Mr F Turner(613)
INV198888,01/09/2015,13.3,Mr F Turner(613)
INV198901,01/10/2015,31.58,Mr F Turner(613)
INV198906,01/11/2015,13.3,Mr F Turner(613)
INV198909,01/11/2015,16.62,Mr F Turner(613)
INV198918,01/11/2015,23.51,Mr F Turner(613)
INV198921,01/12/2015,16.62,Mr F Turner(613)
CREDITCODE1,,-500,Mr F Turner(613)
See the example in Menu: Import a Remittance File
