Hi there! Pilot CEO here. We do accrual bookkeeping by default but we can do cash-basis bookkeeping too, if you require it.
By and large our requirements are around the use of electronic systems to capture data (so, if you have a stack of paper invoices today and you're opposed to using a system like bill.com or similar, it's not going to be a great fit.)
Is reconciliation done also automatically or is there a person checking every bank transaction and confirming the reconciliation?
Afaik quickbooks doesn't offer a reconciliation API, but also I would be skeptical about not having a human confirm every transaction reconciled.
We do the reconciliation—and you're exactly right that QBO doesn't have a reconciliation API, so we have to do it outside of QuickBooks in our own system.
(But yes, we've found that if you don't do this reconciliation, the bank feed will just silently drop transactions, etc.)
Can you clarify a bit more when you say you reconcile "outside of QBO"? Does this mean you're keeping track of reconciled items in a separate system and not in QBO?
In QBO if an invoice payment is reconciled I can see which bank transaction it has been associated with; will this be the case with Pilot?