How to apply VISA payment expense in SAGE 50 CA

Here is our situation: 

Our manager holds a company's VISA card, he uses the card for personal also business purposes. Each month end, I itemizes the transactions, such as office expenses, shop supplies, travel, gas, etc, also personal expenses.  The personal expenses will be applied to his payroll.  How could I apply the accounts for the other expenses? 

Please advise.

Thanks. 

  • 0

    assuming you have the visa card setup as a method of payment, under

     setup -> settings -> company -> credit cards used

    you could create a vendor called 'personal expenses - Bob' linked to the '3015 owners withdrawals' account

    then use payables -> payments -> pay expenses to pay each expense on the CC bill, paid by visa

    ie. pay Staples 100.00 office supplies, pay Bob 55.00 owners withdrawals, etc

    then you can reconcile the visa payable account to confirm that all expenses were recorded

    then use payables -> payments -> pay CC bill to pay you visa bill

  • 0 in reply to Roger L

    Thank you crbookkeeping.

    Then we deduct the owner/manager's withdrawl from their paychqs at the payday.

    How would I record this?

  • 0 in reply to JUDY@RIVER

    Could I be able to link different payable account for different vendor?

  • 0 in reply to JUDY@RIVER

    Hi Judy@River,

    You follow Crbookkeeping's suggestion but change the 3000 equity account to a 2000 level liability account for the manager's expense.   When you pay the expense through make other payment by CC, it will credit the CC payable account and debit the manager's expense liability account.

    Then, you will create a deduction under Setup, Settings, Payroll, deduction just for your manager.  Make it deducted after tax, so it will only affect the net income.  Then, link the new deduction with the 2000 level liability account. 

    When you create the paycheque, input the exact amount from the payment in paragraph 1 to the new deduction under the deductions tab.  It will credit the manager's expense liability account and bring it back to zero. 

    Hope this helps. 

  • 0 in reply to Keith L

    Keith, wouldn't the manager then need to be setup as both a vendor (to pay the expense) and an employee (to deduct from net income) ?  Is there a way to reimburse the employee with an unscheduled payroll cheque/deposit and apply the deduction on the next scheduled payroll cheque ?

    Judy, not sure if/how your question "Could I be able to link different payable account for different vendor?" applies to this thread - are you trying to track what is owed the manager, if so Keith's liability account will do that

  • 0 in reply to Roger L

    Thank you all .

    I have followed crbookkeeping's suggestion, made 2 vendors for 2 CC.  The expenses on regular supplier vendors credit 2000 level  ACCOUNTS PAYABLE - TRADE, we don't want VISA expenses credit on the same 2000 level A/P account,  how could I link VISA vendors to another A/P account, for  example 2XXX -ACCOUNT PAYABLE - VISA;

    Please advise.

  • 0 in reply to JUDY@RIVER

    under setup -> settings -> company -> credit cards used, there is a payable acct field, make it 2XXX-account payable visa

    when you then pay an expense, 2xxx will be credited