Matching problem with payroll transactions
Hello,
How do I match a bank transaction with a payroll liability payment (Child Support payment)?
If I 'spend money' from the bank transaction to the Child support liability GL it doubles the debit but if I 'pay bill' it doesnt exist in the Department of HR card....so where is my liability transaction?
Hi FionaB2 , I now see my first comment was incorrect. The error "invalid date" was probably a reference to the value of 45107 in the first transaction line, which is an Excel date value. You should format that cell as a date (dd/mm/yyyy) without a time value.
For the new error (invalid account number), there is a line with a value of $292.30 where the log is not showing the (internal) account ID. This indicates it may be the problem line. From the original import file, the account number on that line is 6-2027. Can you check the account number on that line and make sure it is postable, eg not inactive or with some other issue?
Some import errors are linked to other causes, so I suggest correcting both issues then retry.