Reconcile coworking access-key deposits across member moves and exits

The useful record links the member, sponsoring company, location, credential, receipt, custody changes, return, approved deduction, and refund. It should follow the access item even when the billing account changes.

Create the deposit row when cash or a processor payment is received. Record the member and company identifiers, location, credential type and serial number, issue date, amount, payment reference, agreement version, and ledger posting. If a company pays one amount for several staff members, document the allocation to individual credentials.

Reconcile deposit receipts to the bank or processor and to the liability account. Then compare the register with the access-control system or physical key log. A paid deposit with no issued credential and an active credential with no deposit require different follow-up.

Avoid matching by member name alone. Company administrators may pay for several users, names can change, and a former member may return under a new employer. Stable member, company, and credential identifiers prevent those histories from being merged.

When a member moves to another building, record whether the original credential was returned, transferred, disabled, or replaced. Keep the original receipt and issue history. Do not create a second deposit liability unless another payment was actually received or management approved a new obligation.

Some systems close the old membership and create a new one at the destination. The deposit register should link both membership records to the same custody history. Record any difference in local deposit requirements and route it for approval rather than silently adding or releasing a balance.

If the member keeps a multi-location credential, show the access scope and effective dates. This helps operations verify custody and helps bookkeeping avoid treating a location transfer as a returned key.

A lost or damaged credential may be replaced while the original deposit remains on account. Link the replacement serial number to the first item and record the disable date, replacement date, reason, fee or added deposit, and approval.

Keep replacement fees separate from refundable deposits. A charge for a new card does not automatically consume the original deposit. The agreement and management decision determine whether the business retains any amount. The preparer records the evidence and approved posting.

Consider a member who reports a lost fob, pays a replacement fee, and later finds the original. The register should show both serial numbers, which item is active, what was paid, whether the original was returned, and how management resolved the fee. Netting all activity into one member balance would hide the custody risk.

When a membership ends, compare the termination record with the credential register. Confirm return or approved nonreturn treatment for every issued item. Record the return date, receiving employee, item condition, access-disable confirmation, and any outstanding replacement.

Do not treat a disabled credential as returned. Access control addresses security, while custody evidence supports the deposit decision. A physical key may have no electronic disable event at all, so the return log remains essential.

Prepare a proposed refund showing the gross deposit, approved deductions, prior partial refunds, amount payable, payee, and payment method. Management should approve deductions and exceptions under the applicable terms. The offshore bookkeeper can assemble the calculation but should not decide that a member forfeits a deposit.

Link the approved refund to the original receipt and member record. Capture payment date, method, transaction reference, and bank settlement. If the payer and refund recipient differ, retain documented authorization.

A payment marked sent is not closed until it settles. Keep failed transfers, stale checks, and returned payments in an exception queue with the current owner and next action date. Do not remove the liability because an attempted payment left the accounts-payable workflow.

For a partial refund, show the remaining balance and why it remains open. If an approved deduction is posted, link the authorization and ledger reference. This preserves the gross liability movement instead of hiding it in net cash.

Route missing serial numbers and return evidence to location operations. Route unmatched receipts and payments to finance. Route agreement questions, deductions, and write-offs to management. A generic "open" status leaves the reviewer to discover who can resolve the item.

Useful exceptions include active credentials without deposits, deposits without issued credentials, terminated memberships with open custody, duplicate serial numbers, transferred members with two liabilities, refunds without settlement, and deductions without approval. Age each exception from the date action first became due.

The monthly packet should show opening deposits, new receipts, approved transfers, refunds, deductions, corrections, and ending liability by location. Tie the total to the exact ledger account and list stale member balances separately. Management reporting support can include the approved rollforward in the close packet.

An offshore bookkeeper can maintain the credential register, match receipts, follow moves and replacements, prepare refund schedules, reconcile settlements, and verify postings. Client management retains agreement interpretation, deduction policy, exceptions, write-offs, and final approval. Bookkeeping services can support recurring preparation under those boundaries.

• U.S. Small Business Administration, Manage your finances
• IRS, Recordkeeping