I’m just curious how everyone else is handling the charge payoff and if there is a better way to do it? I used to download the statement from Ramp but in the last month or 2, they have removed a lot of data from the statement so now I have to go to Expenses, filter by previous statement and download that report. We’re multi-entity so I need to have all the Sage Accounting columns as well as the Ramp columns to decipher which bank accounts were drafted for each company code. Once I match up the charges on the report to the correct bank draft, then I go into Sage and do a charge payoff, checking off each charge one-by-one until I have the correct total (again, that matches the bank draft). This is extremely tedious and, if I’m not careful, Sage will time-out on me and I have to start all over.
I think another way it could be done is by selecting all the items in the charge payoff screen and moving them all over to AP. From there, I could pay a portion of the AP Ramp invoice (just the bank draft amount) but then there would always be some open balance. Not sure if this is ideal. Is anyone doing it this way? How has it worked out for you? Do you then do a credit card reconciliation?
I hear you, reconciling multiple entities and matching transactions to bank drafts can be quite a task. It sounds like you’re looking for a more streamlined process to handle charge payoffs. Here’s a suggestion that might help:
Use the Expenses report to filter transactions by the previous statement period.
Export this data with all necessary Sage Accounting and Ramp columns.
Use this report to reconcile with your bank drafts in Sage, possibly through a bulk import or reconciliation feature if Sage supports it, to avoid manual one-by-one entry.
For multi-entity setups, you’ll want to have a clear mapping of transactions to each entity’s bank account. If Sage times out during manual entry, a bulk operation could save time and reduce errors.
As for moving items to AP and paying off portions of the invoice, this could work, but you’d need to manage the open balance carefully to ensure accurate reporting and avoid confusion.
As a follow-up question, have you explored any automation or bulk processing features within Sage that could assist with this process? Additionally, Ramp Support may be able to explore a more detailed statement that best suits your needs ( [email protected] or call them via 855-206-SAVE).
Would love to hear how other customers are approaching this, please feel free to chime in the thread as well
Good morning, we are doing the same thing with the charge pay off as Sheri. It is extremely time consuming and tedious!!! And we also do the credit card reconciliation. So we end up having to reconcile the credit card twice (for the pay off and the actual reconciliation). Sage has an import for the bank reconciliation, which then allows automation/rules. But there is no import for the credit card payoff or reconciliation. And the pay off is even more work when there is multiple payoffs in one statement period. I would be very interested in hearing if there is another way!
I don’t know if this works since we are single entity, but we are also using Sage Intacct. We do not sync over any transactions for the new month/statement until we’ve booked the payoff for the previous month and reconciled the credit card in Sage. Then all we do after booking the payoff is go into the credit card reconciliation, select all transactions to match, and the entire statement is reconciled without us having to go line by line. It puts us slightly behind in syncing over transactions, but saves hours on the reconciliation.
