Batch debits do not add up to file debit

[sankaet]

Hi,

So I was testing out the sample file and I think the digits are abit off

here is my input (same as your sample input)

from ach.builder import AchFile

settings = {
'immediate_dest' : '123456789', # Your bank's routing number
'immediate_org' : '123456789', # Bank assigned routing number
'immediate_dest_name' : 'YOUR BANK',
'immediate_org_name' : 'YOUR COMPANY',
'company_id' : '1234567890', #tax number
}

ach_file = AchFile('A',settings) #file Id mod

entries = [
{
'type' : '22', # type of
'routing_number' : '12345678',
'account_number' : '11232132',
'amount' : '10.00',
'name' : 'Alice Wanderdust',
'addenda' : [
{
'payment_related_info': 'Here is some additional information',
},
],
},
{
'type' : '27',
'routing_number' : '12345678',
'account_number' : '234234234',
'amount' : '150.00',
'name' : 'Billy Holiday',
},
{
'type' : '22',
'routing_number' : '12323231',
'account_number' : '123123123',
'amount' : '12.13',
'name' : 'Rachel Welch',
},
]

ach_file.add_batch('PPD', entries, credits=True, debits=True)

print ach_file.render_to_string()

Output (same as your sample output)

101 123456789 1234567891407141745A094101YOUR BANK YOUR COMPANY
5220YOUR COMPANY 1234567890PPDPAYROLL 140714 1123456780000001
62212345678011232132 0000001000 ALICE WANDERDUST 1123456780000001
705HERE IS SOME ADDITIONAL INFORMATION 00000000001
622123456780234234234 0000015000 BILLY HOLIDAY 0123456780000002
622123232315123123123 0000001213 RACHEL WELCH 0123456780000003
822000000400370145870000000000000000000172131234567890 123456780000001
9000001000001000000040037014587000000000000000000017213
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999

Error:

[travishathaway]

Sankaet, next time please use the source code markup for markdown or provide a pastebin link. It makes the example code you have shown much easier to read :)

Thanks for bringing this to my attention. It looks like the error may have been caused by the decimal places being off by two. I have gone back read the file specs for the file control and applicable entry detail record definitions, and everything is where it should be.

Also, I have run validation against the ACH file using this software: http://www.achworks.com/index.php/en/products/ach-tools/achfilechex and received no errors related to the total amounts. The only errors I received were regarding routing numbers, but I am pretty sure this is only because they are fake.

Additionally, before the 0.2 release I worked with another developer who was able to verify the files with their financial institution.

What tool are you using to validate these ACH files?