Bank & Credit Statements Automate Entries

Hi All. Sage 100c 2017.

I would like to know what people use to automate bank & credit transactions that were not for invoices paid for by credit card. For example lunches, travel, etc. Do you just export the statements into Excel and code that way and then just import with VI or is there a simpler way?

Thanks!