Credit Card Processing For Expense Entry

From Agency Systems Wiki
Revision as of 20:11, 4 September 2014 by Mlively (Talk | contribs) (link typo)
Jump to navigation Jump to search
Related Pages
Related Categories
Using Credit Cards to Enter Expense Transactions

All non-policy related expense transactions are recorded as wire or regular checks using the Non-Policy Related Checks interface.

The interface supports multiple General Ledger Profile expense entries per transaction. The checks are all recorded under GL 2130: Vendor Payables. When a transaction is recorded, the debit is recorded against the entered Bank Profile, which can be a bank account, or an alternate bank account such as a credit card.

This procedure outlines the day-to-day process of recording expense entries using a credit card, and posting a credit card payment against the balance.

  • Each expense transaction is recorded individually, to the appropriate vendor (Electronic Store, Utility Company, Grocery Store etc).
  • Entries can be recorded immediately instead of as a lump sum at the end of the month.
  • The current credit card balance can be viewed from the Balance Sheet.
  • Reports can be completed for total expense based on type, or total expense per vendor.
  • Credit Card statements can be reconciled in Newton using Bank Reconcile.

(Alternatively, if individual transactions for each expense are not desired, and reports by vendor are not needed, a single non-policy related check can be created with each expense general ledger account entered as a monthly total.)

Create a New Credit Card Bank Profile

All expenses will be recorded to a dedicated Bank Profile, which represents a credit card balance.

  1. Select Profiles -> Bank.
  2. Select Add.
  3. Enter a unique code (From Example: 300).
  4. Enter a name. (From Example: CC MC 9999).
  5. Select Save -> Exit.

Cc-bankprofile.png

Create Expense Entry Charged to Credit Card

For more information regarding vendor payables, see Non-Policy Related Checks.

  1. Select AP -> Check Transaction -> Non-Policy Related.
  2. Enter the Vendor Code.
  3. Enter the credit card Bank Code. (From Example: 300)
  4. Enter the Payable Date.
  5. Enter a short Description.
  6. Enter the GL Code for the expense.
  7. Enter the Department Code.
  8. Enter the Sub GL if necessary.
  9. Enter the Amount.
  10. Select Accept.
  11. Repeat steps 6-10 until all GL entries are listed.
  12. When finished, select Save, then Exit.

Example: Two Vendor Payable Transactions

Cc-checkentry.png Cc-checkentry2.png

Enter additional checks for each expense charged to the credit card.

View Credit Card Balance

The expense entries will be automatically posted to the system General Ledger, and available on a number of reports.

View Balance Sheet Entries

All bank codes are displayed under GL 1100, including the current credit card balance.

Cc-balancesheet.PNG

View GL Detail Entries

GL -> General Ledger Detail for GL 1100 SubType 300 displays all transactions for the specified period.

Cc-gldet-filters.png

Cc-gldet-report.PNG

View Income & Expense Entries

GL -> Income & Expense displays the totals entered for each expense GL.

Cc-incexp.PNG

View Vendor Payable Entries

AP -> Check Reports -> Check Register displays the totals entered for all vendors, or for a specific vendor if a Sub GL is used.

Cc-checkreg-filters.png

Cc-checkreg-report.PNG

Pay Credit Card Balance with Bank Transfer

See Bank Transfer for setup and additional instructions.

  1. Select GL -> Bank Transfer.
  2. Enter the Source Bank Code.
  3. Enter the Destination Bank Code for the credit card. (From Example: 300)
  4. Enter the Payment Amount.
  5. Confirm the remaining details and select Ok.
    Cc-banktransf.png
  6. The transfer between bank accounts will be processed and a confirmation displayed.
    Cc-banktransf-complete.png

When finished, a GL Detail Report will display the transfer, adjusting the bank balance.

Cc-banktransf-gldet.PNG