Entries for credit cards

Hello Forum - I am a newbie to Manager.io and am still learning the software. I am also not super great at double entry accounting and need help.

My specific problem is properly categorizing transactions where a purchase is made on a business credit card. I am importing bank data into Manager and that is working fine. The problem I am having is reconciling the credit card. I thought everything was working fine but the transaction details in the Bank Reconciliation environment show negative numbers where the entries should be positive and vice versa. Somehow debits and credits are reversed or something.

The credit card is set up as a Liability account.

I have been categorizing the “payments” transactions from the imported bank data as follows:

  1. Paid From Account: Credit Card
  2. Account: [name of Expense Account]
  3. Amount: is a positive number, coming from the bank feed

This makes sense to my brain because a third party got “paid” using the credit card and the type of expense is where I want it to be categorized.

The problem I do not know how to solve shows up when I try to reconcile the credit card account.

When I put in the opening and closing balances, it shows as “not reconciled.” Manager is capturing the right line items in the Bank Reconcilation -Edit screen but the signs are reversed.

Is a simple solution to enter the balances as negative numbers or something? An outstanding positive balance for a liability account on the balance sheet should be a positive number.

This is probably rudimentary to most of you but I am not an accountant and just need a simple explanation or help here.

Many thanks in advance!

JSP

Hello @jscott2026,

Welcome to the forum.

The best method imo, is to create your credit card as a Bank or Cash Account.

To do that, you first need to create a control account from Settings > Control Accounts > Bank and Cash Accounts

From there create a control account to hold your credit cards under Liabilities.

Then, you can go to Bank and Cash Accounts and create an account for your credit card under the control account you just created.

This way you can use your credit card to create Payments normally.

In order to reimburse your card, you can use Inter Account Transfers

The forum is not for accounting help, but for use of Manager. In many forum topics reference is made to use the free accounting learning resource https://www.accountingcoach.com/ which explains very important basics such as:

  1. The accounting equation(helps to understand the balance sheet info (left-side of Manager summary screen) https://www.accountingcoach.com/blog/accounting-equation
  2. The profit and loss statement (right-side of Manager summary screen) https://www.accountingcoach.com/blog/what-is-the-profit-and-loss-statement
  3. And understanding how Debits and Credits works. This is the most important part to learn.The pretty extensive guide at https://www.accountingcoach.com/debits-and-credits/explanation helps you to understand how it all works.

Yes. When entering the balance reported on the card statement it should be entered as negative (because you owe money to that account). If you were entering them as positive numbers, switching them to negative should clear up the “Not Reconciled.”

Not strictly. This can be a little wonky but, by convention, all balances on a balance sheet are shown as positive numbers; the trick is knowing whether those positive numbers represent debits or credits.

Liabilities are credits, which accounting programs generally handle as negative numbers (this is why the transaction details in the Bank Reconciliation are showing as negative; by using a credit card you’re borrowing money, so you have a liability and all the amounts are credits). Then by entering the statement balance in the reconciliation as a negative you’re basically telling Manager “I have a credit balance on this account” and Manager can check whether that credit balance equals the total of the credits in the transaction detail.

thanks p4unger for your response. That is helpful.

thanks for the reply Ealfardan. I will dig into the control account method more. I think that is the way to go.

Thanks eko, those are great references. For what its worth, I think my accounting understanding was enough to figure out I have an issue, and the issue is really figuring out how to do this correctly in Manager. So I will keep plugging away.

Credit card purchases for business expenses.
I have enabled Expense Claims, and created an Expense Claim Payer (the credit card).
I created an expense claim, paid by the Expense Claim payer (credit card), and listed the gl expense account (office expenses) in the Account field in the detail line.

All good so far (I think), as the summary shows the Expense claim amount in the Liabilities of the Summary, and can also drill down in the Expenses to see the individual expense line amount as well.

Making the Payment for the expense claims is where I am not following.
At the time to pay the cc statement (manual reconcile, not imported or anything like that), how do I record the cc statement payment to offset against the Expense Claim Payer? In the Payments screen, the Payee drop down does not list the Expense Claim Payer?

Am I missing a setup step? Or am I not following the correct method?

You should use a Credit Card account to record purchases made by a company credit card, not an Expense Claim Payer

The card fee is then an expense recorded as a purchase and the balance payment as an inter-account transfer

I am following the instructions from the “Set up credit cards” page, I have the Bank and Cash Account set for the CC. I have the GL liability account “CC acct payable - 20005”, and in the Bank and Cash Account, I have the 20005 entered as the Code.

When I record a Payment (I assume this is what you mean when you say record as a purchase), I enter the Bank account as the Paid From, and log the Account in the detail as the GL Expense account.

I am unclear on what should be entered into the Payee selection?

At this point, in the Summary, I see the Expense listed, but nothing in the Assets or Liabilities?

What step am I missing?

What payment are you talking about?

If it is a payment for a purchase paid b the Credit Card - select the Credit Card as the Paid from Account and enter the expense account in the item line

If it is the payment from the bank account to settle the Credit Card account, use the Inter-Account Transfer tab and enter the Bank account in the Paid from account and the Credit Card in the Received in account

@Joe91

Here are screen shots to show, and help clarify what I am doing (possibly incorrectly).

For reference, I am using the Desktop version 26.11.5

Bank & Cash account:

Liability Account:

Payment (purchase of goods on credit card)

Payment of the CC statement will be done via Inter-Account Transfer (between the Bank accounts), not performed yet.

Summary screen does not show the CC purchase? I am expecting to see an amount in the CC Accts Payable in the liability section? What did I miss, or do incorrectly?

As you have only shown partial screenshots, some important data is not shown - for example it is impossible to see what period you are showing

Please show full screen shots

Here are full screen shots.

In the Summary screen, I can see the cc purchase listed in the 70018 Office Expenses, and clicking on the amount for the Cash & cash equivalents, I can see the cc purchase here listed as a CR.

But shouldn’t it also show in the Summary Liabilities section in the 20005 CC Accts Payable since this was the account it was recorded as the Paid From? Based upon what I read at: https://www2.manager.io/guides/7035

Summary (page 1)

page 2

Bank account for the CC

Payment (cc purchase)

When looking at the Bank and Cash accounts, I can see the amount for the cc purchase in the Chase Ink bank account.

First, you should use the Edit button on the Summary to correctly specify the period and format (cash or accruals) to be used

Second, as you chart of account is currently defined, your credit card account Chase Ink is included in the Cash & Cash Equivalents on the Balance Sheet but as a negative value as you can see when you drill down on the figure 401.01

If you want to see it in the liabilities section you have to create a custom control account for bank accounts as described in the guide https://www2.manager.io/guides/9256 and then follow the instructions in the first guide I linked to

I moved your topic here where the answer is in the second post: