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:
Paid From Account: Credit Card
Account: [name of Expense Account]
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.
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:
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 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?
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?
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
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?
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
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