Hi Hamdana:

I would suggest to you to setup the credit card in Sage and choose it when entering payables. It will post directly to the credit card rather than payables. You will choose the vendor, amount, and account as usual, just enter payment method as the credit card.

Hope this helps!

Here's a blog on How to set up credit cards for payments to vendors in Sage 50 CA*

These are debit card purchases for g&a items, I want to avoid entering them individually.

Not entering them individually means you will have a rough time doing bank recs and you will have to do some math to get them done.

You can keep all the receipts in an envelope and post them as one entry at the end of each month, but you will not be able to manage cash flow easily because you will not have updated your books for a month.  These small items sometimes add up to hundreds of dollars.

You can fill out a spreadsheet of all the receipts and post them as one entry at the end of each month.  This will maintain a total you can subtract from your bank balance each time you need to do cash flow analysis and give you one entry at the end of each month.  If you keep an invoice total on the spreadsheet as well, you can use it to check off the balances as they show up on the bank statement when you do reconciliations.

Generally I've found it more work to find ways to not post them individually than to just post them as you get them.

Agate's idea of setting up a credit card is a good one also.  You can set it up as DP (Direct Payment) and use the bank account in the setup,  That way you can just pick the payment method from the payment method drop down.  If you do post them individually, you can keep the original invoices posted under the original vendor name so you can find them easier afterward.

Hi Richard, thanks for your response. Ill have to adjust my methods here.

One more question regarding these transactions. As i have a list of the items, is it possible to do a import from a csv file to hit the proper GL in my current version?

Technically yes but the import formatting is picky and you would still have to type it into a similar grid-like setup like the Purchase data entry screen, then pray it transfers over properly.

For this specific scenario, I would probably experiment with compiling all the individual invoices throughout the month and as you receive them, enter them into a single Vendor Quote form or Recurring entry with one or more rows per invoice.

Record the Quote or resave the recurring entry each time you update it.  Then at the end of each month, validate and post it as a purchase.  No more data entry and the process of posting has already been programmed.  The Quote will be removed from the system for you to start over or you can just keep reusing the recurring entry.

I've been praying lots with Sage. Nonetheless I'll script something together that will populate the format correctly and try it out. 

I just want to clarify for this exercise that I'm not working with Invoices from prime vendors with that documents with invoice numbers, but receipts from Home Depot for nuts and bolts and Staples for USB chargers, or Tim Horton's for coffee runs.