Record credit card transactions

Summary

How to record credit card transactions in Sage Accounting.

Description

Create a bank account to track and create credit card transactions. This will also help you track spending on credit card.

Some credit cards also have a bank feed. Linking your credit card to a bank feed will allow you to import transactions from your credit card. This will ensure your transactions are always up to date.

Resolution

What you need to do

To record credit card transactions, we recommend that you:

Create a bank account to manage your business credit card. Make sure you also enter your opening balance. This is the balance of your credit card when you start entering transactions into Sage Accounting
Optional - create a new ledger account for credit card charges and interest. This is so you can keep them separate from other bank accounts. Otherwise you can record the interest and charges to the same ledger account you use for other bank accounts
Reconcile the credit card transactions in the bank account when you receive a statement

Create a bank account for your credit card >

From Banking, then select New then Bank Account.
For the Account Type list, choose Credit Card.
This adds a credit card icon to tile to help you identify it.
Enter an account name to help you identify this as your credit card.
Enter the remaining details if required.
Select Save.

Enter an opening balance

It's likely that you will already have an amount on your credit card. You now need to enter this as an opening balance to make sure your balances match up.

Choose the Add Opening Balance link.
Enter the balance of credit card as the:
- Card Balance. If the credit card has a positive opening balance. This when you have a positive balance with your credit card company
- Overpayment. if the you owe money on your credit card account This is the most likely balance to have for a credit card

Connect to a bank feed

Choose Save and Connect Bank to connect to the credit card account with the bank.

Once connected, import transactions from you credit card account.

Create a ledger account for credit card charges >

Optionally, create a new ledger account to record the amount paid in charges and interest on your credit card.

Go to Settings, then in Financial Settings, select Chart of Accounts.
Select ledger account and complete the following information:
- Name - give the ledger account a name such as credit card charges
- Display Name - this is the name to show on reports and lists
- Code - give the ledger account a code. If you're using our default chart of accounts, we recommend that this is between 7000 and 7999, such as 7901
- Category - choose Overheads. This is to make sure the amount you report the amount as an expense on your profit and loss report
- VAT Rate - choose Exempt. VAT is not applied to bank charges and interest
- Visibility - leave the defaults as selected. This determines which transactions to use the Ledger accounts with

Select Save.

Record payments made with your credit card >

If your credit card is not connected to a bank feed, you'll need to manually enter your credit card transactions.

Or, consider importing them from your credit card statement.

If you're paying a supplier invoice, use the Supplier Payment option. This allows you to match the payment with the invoice.

For other expenses, use the Other Payment option.

From Banking, open the credit card account.
Choose New, then Purchase / Payment.
- To pay a supplier, select Supplier Payment
- For any other payment, select Other Payment
Enter the details of the payment:
If the payment was for several items relating to different ledger accounts, or with different VAT rates, enter these on separate lines.
Don't forget, the total value of all the separate lines must add up to the total value of the payment.
Select Save.

Record credit card charges and interest >

When you reconcile your credit card statement and want to record your credit card charges in separate ledger accounts, enter them as an Other Payment.

Otherwise, enter the charges when you reconcile.

From Banking open the credit card account.
Select New, Purchase / Payment then choose Other Payment.
Enter the details of the charges or interest:
- Paid from Bank Account - choose your credit card account
- Method - the Credit Card option is probably the most relevant
- Date Paid
- Ledger Account - Choose the ledger account you have just created for credit card charges
- VAT Rate and VAT - choose Exempt

Transfer money to pay your credit card bill >

As you use money from another bank to pay your credit card bill, record this using the Bank Transfer option.

From Banking, choose New, then Bank Transfer.
Enter the details of the transfer and Save. You must enter the following:
- Paid from Bank Account - the bank account you paid your credit card from
- Paid into Bank Account - your credit card account
- Amount Transferred
- Date Transferred

Record a refund on your credit card >

If you've received a refund on your credit card, you'll need to record this too.

Record a money in refund

From Banking, open the credit card account.
Select New, then Sale / Receipt.
Choose Other Receipt tab, then Enter a refund for a purchase link.
Enter the details of the refund.

Record a money out refund

From Banking, open the credit card account.
Select New, then Purchase / Payment.
Choose Other Payment tab, then the Enter a refund for a sale link.
Enter the details of the refund.